The below undocumented DBCC command is working in both SQL Server 2000 & SQL Server 2005
DBCC LOG([,{0|1|2|3|4}])
0 – Basic Log Information (default)
1 – Lengthy Info
2 – Very Length Info
3 – Detailed
4 – Full Example
Syntax:
DBCC log (MY_DB, 4)
0 – Basic Log Information (default)
1 – Lengthy Info
2 – Very Length Info
3 – Detailed
4 – Full Example
Syntax:
DBCC log (MY_DB, 4)
Another undocumented command is DBCC LOGINFO
reference: (also lists recovery tools)
Comments
Post a Comment