DBCC SQLPERF(LOGSPACE)orCREATE TABLE #LogSpace(
DatabaseName sysname NOT NULL,
LogSizeMB numeric(9,2) NOT NULL,
LogSpaceUsedPercent numeric(5,2) NOT NULL,
Status int NOT NULL)INSERT INTO #LogSpace
EXEC('DBCC SQLPERF(LOGSPACE)')SELECT LogSizeMB, LogSizeMB/LogSpaceUsedPercent*100 FROM #LogSpace
WHERE DatabaseName = DB_NAME()DROP TABLE #LogSpace
DatabaseName sysname NOT NULL,
LogSizeMB numeric(9,2) NOT NULL,
LogSpaceUsedPercent numeric(5,2) NOT NULL,
Status int NOT NULL)INSERT INTO #LogSpace
EXEC('DBCC SQLPERF(LOGSPACE)')SELECT LogSizeMB, LogSizeMB/LogSpaceUsedPercent*100 FROM #LogSpace
WHERE DatabaseName = DB_NAME()DROP TABLE #LogSpace
select count(*) from ::fn_dblog(null,null) --一个未公开的table-valued funtion 可以看日志文件的记录数