Solved

Transaction Log Reader

Posted on 2000-03-09
8
3,477 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

626 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