How to read transaction log data in SQL Server 2000/2005?


 

We can’t read the transaction logs directly from SQL Server. Some products do allow you to read the logs, such as:

* Apex SQL Log (Works with MSSQL2000 and MSSQL2005)
* Log Explorer
* SQL Log Rescue (Only work with the SQL Server 2000)

The below undocumented DBCC command is working in both SQL Server 2000 & SQL Server 2005

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
Syntax:
DBCC log (MY_DB, 4)

Another undocumented command is DBCC LOGINFO

3 thoughts on “How to read transaction log data in SQL Server 2000/2005?

  1. amit sharma

    dear i want to restore my data base from transaction log but i dont know how i can i done this job ……….and where i can find transaction log in sql 2005 . how can i enable transaction log …kindly provide me all details about transaction log …..

    Reply

Leave a Reply to Jugal Shah Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s