Solved

Transaction Log Reader

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

762 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

17 Experts available now in Live!

Get 1:1 Help Now