«
»

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

Posted by Jugal Shah on April 16, 2008


 

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

This entry was posted on April 16, 2008 at 10:04 am and is filed under SQL Server. Tagged: . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “How to read transaction log data in SQL Server 2000/2005?”

  1. Vlad said

    May 5, 2010 at 10:30 pm

    I have no backups in my DB and I restored deleted rows from transaction log using SQL Log Rescue. Thanks!

    Reply

  2. amit sharma said

    November 21, 2011 at 11:37 am

    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

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

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

Gravatar
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 )

Cancel

Connecting to %s

«
»
 
Follow

Get every new post delivered to your Inbox.

Join 175 other followers