Archive for the ‘Sql Server’ Category

This is undocumented sp to read the logfile.

select * from fn_dblog(null,null)

This is one more undocumeted sp to find out number of VLF.
DBCC LOGINFO

Status 2 => VLF in use
Status 0 => VLF not in use.

convert this post to pdf.

Posted by Borndba on September 9, 2009 at 3:54 pm under Sql Server.
Comments Off.