当然,我假设您不使用WITH NO_TRUNCATE或WITH COPY_ONLY语法进行日志备份任务.

以下3个查询应该可以让您了解填充的日志内容：

use [<myproblemdb>];
go

select count(*) as CountLogRecords,sum([Log Record Length]) [Total Log Length]
from fn_dblog(null,null);

select count(*) as CountTransactionRecords,sum([Log Record Length]) [Transaction Log Length],[Transaction ID]
from fn_dblog(null,null)
group by [Transaction ID]
order by 2 desc;

select count(*) as Countlogoperations,sum ([Log Record Length]) as [Operation Log Length],[Operation]
from fn_dblog(null,null)
group by [Operation]    
order by 2 desc;