Wednesday, March 28, 2012

How can I read the content of transaction log

How can I read the content of transaction log?How can I read the content of transaction log?
Use DBCC LOG to view Transaction 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)

to understand transaction log see this ...Link (http://www.windowsitlibrary.com/Content/77/21/1.html)|||Thanks :-)

No comments:

Post a Comment