SQL Server 查看数据库日志

DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )
　　参数:
　　Dbid or dbname - 任一数据库的ID或名字
　　type - 输出结果的类型:
　　0 - 最少信息(operation, context, transaction id)
　　1 - 更多信息(plus flags, tags, row length)
　　2 - 非常详细的信息(plus object name, index name,page id, slot id)
　　3 - 每种操作的全部信息
　　4 - 每种操作的全部信息加上该事务的16进制信息
　　默认 type = 0
　　要查看MSATER数据库的事务日志可以用以下命令：
DBCC log (master)

[@more@]

DBCC log (tsp2)

000003df:00000010:0078 LOP_BEGIN_CKPT LCX_NULL 0000:00000000 BINARY, 2 Bytes 96 96 000003de:00000160:0001 BINARY, 2 Bytes (null) (null) (null) (null) (null) (null) (null) (null) (null) 2012/06/06 11:23:46:890 611 0000:00124219 (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null)
000003df:00000041:0001 LOP_END_CKPT LCX_NULL 0000:00000000 BINARY, 2 Bytes 136 136 000003df:00000010:0078 BINARY, 2 Bytes (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) 2012/06/06 11:23:46:923 611 000003df:00000010:0078 36 00000000:00000000:0000 00000000:00000000:0000 00000000:00000000:0000 00000000:00000000:0000 (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null)
000003df:00000042:0001 LOP_BEGIN_XACT LCX_NULL 0000:0012421a BINARY, 2 Bytes 48 84 00000000:00000000:0000 BINARY, 2 Bytes (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) 0 -1 131 BINARY, 4 Bytes 2012/06/06 11:23:49:720 INSERT BINARY, 16 Bytes (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) INSERT;0x6efd1470e725d14eae6305cf7a938f78 (null) (null) (null) (null) (null) (null) (null) (null) (null) (null)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26273052/viewspace-1059114/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26273052/viewspace-1059114/