20100909 使用 DBCC LOG 來檢視交易記錄檔內容

建議使用 DBCC LOG 來檢視交易記錄檔內容。

DBCC LOG:
This command is used to view the transaction log for the specified database.

Syntax:
DBCC log ({dbid|dbname}, [, type={-1|0|1|2|3|4}])

where:

dbid or dbname - Enter either the dbid or the name of the database

type - is the type of output, and includes these options:
0 - minimum information (operation, context, transaction id)
1 - more information (plus flags, tags, row length, description)
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 row.
-1 - full information about each operation plus hexadecimal dump of the current transaction log's row, plus Checkpoint Begin, DB Version, Max XDESID
by default, type = 0

To view the transaction log for the master database, run the following command:
DBCC log (master)

reference:http://social.msdn.microsoft.com/Forums/zh-TW/240/thread/61beefd4-03ff-44c8-a685-8b6de580cc4b