发现一个数据库的日志文件达到33 GB。
执行
select log_reuse_wait_desc from sys.databases where name='dbname'
返回的结果为ACTIVE_TRANSACTION
但是执行下面却有返回
USE DBName
go
DBCC OPENTRAN()
返回结果集为
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.