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

About these ads

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

  1. 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 …..

Thanks for the comment, will get back to you soon... Jugal Shah

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s