Database question

Grindorin

Under SQL Server 2000, is it possible to review the transaction log for a specific database? If so, how? Semper Fidelis

Arjan Einbu

On http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm[^] I found this:

8. 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}] )
PARAMETERS:
Dbid or dbname - Enter either the dbid or the name of the database
in question.

  type - is the type of output:

  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)

Also, there are some third-party tools that will let you look into, and manipulate db-logs...

Grindorin

This is what I needed. Thank you for your help. Semper Fidelis