Undo transactions using the transaction logs

Posted on 2006-05-04
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

    Can you try Lumigent Log Explorer ..
    LVL 30

    Expert Comment

    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

    Hi nmcdermaid,

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

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
    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…

    755 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