Undo transactions using the transaction logs

Posted on 2006-05-04
Medium Priority
Last Modified: 2008-01-09
Dear experts,

We are running some system on a sql database with hundreds of tables. One of the staff members ran an end-of-month business process on the database using wrong parameters last Sunday. The mistake was only realised yesterday morning when customers started complaining about errors in there profiles. What we need to do now is to try and revert back to the database state as of end of day on Saturday using transaction logs i.e. just before the end-of-month process was run. Take note that we don't have Saturday's backup; we only have backups that were created after the mistake hence we cannot restore an earlier database.

We have tried to use the 3rd party applications "SQL Backup Rescue" and "Apex SQL Log" but both applications can only reverse additions and deletions ("INSERT" and "DELETE") but not updates; On updates, they both report that they "cannot reconstruct the re-do or un-do queries" for all but a few updates. We suspect these updates were performed using bulk queries as some of them show the same "Begin Time".

Any ideas are most welcome;

Question by:bmatumbura
LVL 75

Accepted Solution

Aneesh Retnakaran earned 500 total points
ID: 16603784
Can you try Lumigent Log Explorer ..
LVL 30

Expert Comment

ID: 16603992
Is the recovery model set to 'Full'?

If so then it may be possible to do a 'point in time' restore (though I have never done one myself)

Do you have ~any~ backups from prior to the change?
LVL 11

Author Comment

ID: 16604700
Hi nmcdermaid,

unfortunately, the recovery model is set to "Bul-Logged" and there are no backups prior to the change.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

862 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