DBCC 查看日志

1.  DBCC LOGINFO

2. DBCC SQLPERF(logspace)

    显示日志空间使用情况

2.  DBCC LOG(<database name>[,{0|1|2|3|4}])

        0 - Basic Log Information (default)
        1 - Lengthy Info
        2 - Very Length Info
        3 - Detailed
        4 - Full

     Example: DBCC log (MY_DB, 4)

     And it displays the following transaction log information:
         Current LSN
         Operation (string starts with LOP_XXXXX)
         Context (string starts with LCX_XXXX)
         Transaction ID
         Tag Bits (Hex)
         Log Record Fixed Length (int)
         Log Record Length (int)
         Previous LSN
         Flag Bits (Hex)
         Description (string)
         Log Record (Hex)