Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    6

    Unanswered: How can I read the content of transaction log

    How can I read the content of transaction log?

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by VArquero
    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
    Last edited by rudra; 10-30-06 at 09:30.
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  3. #3
    Join Date
    Sep 2006
    Posts
    6
    Thanks :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •