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

Written by

Jugal Shah

in

 

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

Comments

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

  1. Vlad Avatar
    Vlad

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

    Reply
  2. amit sharma Avatar
    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
    1. Jugal Shah Avatar
      Jugal Shah

      Hi Amit, I have answer your question in SQLDBPool forum. Please check the forum and let me know if you need more information.
      http://sqldbpool.forumotion.in/t7-restore-db-from-transaction-log#12

      Reply

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

More posts