Friday, July 18, 2008

DBCC LOG

There is an undocumented command for checking SQL Server transaction log file for 7.0 and 2000.

To use it: DBCC log(dbname|dbid, [type=-1|0|1|2|3|4])

The meaning of type is

-1: 4 + hex dump of low row info, checkpoint begin, DB version, and Max XDESID

from 0 to 4, more information about the transaction is retrieved. Default value is 0.

No comments: