Solved

Transaction Log Reader

Posted on 2000-03-09
8
3,465 Views
Last Modified: 2008-03-10
Does there exist a tool to read/analyse the transaction log / dump of the transaction log of SQL Server 7 ?
0
Comment
  • 4
  • 3
8 Comments
 
LVL 6

Expert Comment

by:Jon_Raymond
ID: 2603168
No, there does not.  The log cannot be read.  The closest thing to reading the log is to query the INSERTED and DELETED tables through a trigger.  If you need to read the log to track what is goin on you could create triggers on the tables.  The triggers could query the INSERTED and DELETED tables and write the results to another log table that you create.  You could also add a date/time stamp field to track when the activity happens.
0
 
LVL 142

Author Comment

by:Guy Hengel [angelIII / a3]
ID: 2604270
But should it not be possible to read the transaction log backup (the SQL Restore can read it ?! )
0
 
LVL 6

Expert Comment

by:Jon_Raymond
ID: 2604812
You mean is it possible to restore the log?  Yes, of course.  If not there may be some other problem, like corruption.  You may have to restore the database and log together that were backed up at the same time.
0
 
LVL 142

Author Comment

by:Guy Hengel [angelIII / a3]
ID: 2605074
Let's turn the sentence the other way:
I have a transaction log backup, and i want to analyse it to find out who has done what operation BEFORE doing the restore.
The question is in fact to find out when the operation has been performed to be able to do the restore to the moment just before.
I know how to restore a (transaction log) backup, but i need to know to what moment before i do the actual restore.
Otherwise I would have to do test restores and find out what happend (which would take some time on the 1,4 GB database with over 100 tables...)
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 6

Expert Comment

by:Jon_Raymond
ID: 2608730
If I understand, you have a database backup with multiple transaction log backups between database backups.  So, you want to restore some of the transaction backups up to a certain point, which is yet to be determined.

If so, this is the reason for doing tranaction log backups.  You restore one at a time until you find the point where some problem occurs (or just before that point).  So, there must be some tell-tale sign of whatever it is that you are looking for - like some record got deleted.  So, if it is a flag record like that, you will have to restore each log and check that flag each time.  When you've restored one too many then you know the previous log restored is the one you stop with.  Then you have to kill the database and run the restore process again.  Perhaps you already are aware of all this.  But, if you could just read logs to determine at which point something happened, don't you think that would be a known procedure and required reading for training?  It sounds like a revolutionary concept that would advance the restoration process beyond it's present state.  I doubt there is any way or third party utility to do this.  
0
 
LVL 6

Accepted Solution

by:
Jon_Raymond earned 50 total points
ID: 2608739
When you say the restore can read it - no, the restore doesn't read the log, it just restores it to the database so you can read the restored database at that point.
0
 
LVL 142

Author Comment

by:Guy Hengel [angelIII / a3]
ID: 2609598
I understand that there seems no SQL Server external tool to exists able to analyse the log backup, even if SQL server knows internally how to do :-(
If you fall over such a tool, it would be great if you informed me.
Thanks

0
 

Expert Comment

by:veyselcandemir
ID: 7349026
Yes, a tool exists for reding transaction log records. It is Lumigent Log explorer. If you want more information about it, send a mail to veyselc@banksoft.com.tr
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now