Solved

Transaction Log Reader

Posted on 2000-03-09
8
3,469 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 143

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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 143

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
 
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 143

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
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…

792 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