Thursday, December 24, 2009

DBCC log

DBCC log ( {dbiddbname}, [, type={01234}] )

PARAMETERS:Dbid or dbname - Enter either the dbid or the name of the database in question.type - is the type of output:

0 - minimum information (operation, context, transaction id)

1 - more information (plus flags, tags, row length)

2 - very detailed information (plus object name, index name, page id, slot id)

3 - full information about each operation

4 - full information about each operation plus hexadecimal dump of the current transaction log's default type = 0

To view the transaction log for the master database, you can use the following command:

DBCC log (master)

1 comment:

  1. you can quickly reproduce the .mdf data recovery tools with another utility for data recovery