日志：
2014-07-31 15:21:31.38 spid14s Error: 9002, Severity: 17, State: 4.
2014-07-31 15:21:31.38 spid14s The transaction log for database 'HQ_MS_AYSR' is full due to 'ACTIVE_TRANSACTION'.
2014-07-31 15:21:32.40 spid14s Error: 9002, Severity: 17, State: 4.
2014-07-31 15:21:32.40 spid14s The transaction log for database 'HQ_MS_AYSR' is full due to 'ACTIVE_TRANSACTION'.
2014-07-31 15:21:32.42 spid14s Error: 3314, Severity: 21, State: 3.
2014-07-31 15:21:32.42 spid14s During undoing of a logged operation in database 'HQ_MS_AYSR', an error occurred at log record ID (4114:520:325). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
2014-07-31 15:21:32.43 spid14s Database HQ_MS_AYSR was shutdown due to error 3314 in routine 'XdesRMReadWrite::RollbackToLsn'. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.
2014-07-31 15:21:32.48 spid67 错误: 9001，严重性: 21，状态: 1。
2014-07-31 15:21:32.48 spid67 The log for database 'HQ_MS_AYSR' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
2014-07-31 15:21:32.48 spid60 错误: 9001，严重性: 21，状态: 1。
2014-07-31 15:21:32.48 spid60 The log for database 'HQ_MS_AYSR' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
2014-07-31 15:21:32.49 spid14s Error during rollback. shutting down database (location: 1).
2014-07-31 15:21:32.50 登录 错误: 18456，严重性: 14，状态: 38。
2014-07-31 15:21:32.50 登录 Login failed for user 'AYD\aydax'. 原因: 无法打开明确指定的数据库“HQ_MS_AYSR”。 [客户端: <local machine>]
2014-07-31 15:21:32.50 登录 错误: 18456，严重性: 14，状态: 38。
2014-07-31 15:21:32.50 登录 Login failed for user 'AYD\aydax'. 原因: 无法打开明确指定的数据库“HQ_MS_AYSR”。 [客户端: 192.168.19.41]
-------------------------------------------------------------------------------------------
因为是2012，所以dump transaction、backup log等都没法用。像DBCC SHRINKDATABASE(库名)什么的，看日志吧
2014-08-01 13:09:16.32 spid5s 0 transactions rolled back in database 'ReportServer$ASYNCSERVER' (5:0). This is an informational message only. No user action is required.
2014-08-01 13:09:16.36 spid9s Starting up database 'tempdb'.
2014-08-01 13:09:16.47 spid21s The Service Broker endpoint is in disabled or stopped state.
2014-08-01 13:09:16.48 spid21s The Database Mirroring endpoint is in disabled or stopped state.
2014-08-01 13:09:16.51 spid21s Service Broker manager has started.
2014-08-01 13:09:19.46 spid5s Error: 9002, Severity: 17, State: 1.
2014-08-01 13:09:19.46 spid5s The transaction log for database 'HQ_MS_AYSR' is full due to 'CHECKPOINT'.
2014-08-01 13:09:19.46 spid5s Error: 3314, Severity: 21, State: 1.
2014-08-01 13:09:19.46 spid5s During undoing of a logged operation in database 'HQ_MS_AYSR', an error occurred at log record ID (4114:520:325). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
2014-08-01 13:09:20.47 spid20s Error: 9002, Severity: 17, State: 1.
2014-08-01 13:09:20.47 spid20s The transaction log for database 'HQ_MS_AYSR' is full due to 'CHECKPOINT'.