SQL Server Performance

reverting back the table data after it got changed

Discussion in 'Performance Tuning for DBAs' started by ssathish, Feb 17, 2003.

  1. ssathish New Member

    Hai everyone,
    I got my data in SQL server. the data in table got changed by the application. My COM dll uses adodb, which inturn call stored procedure and changed the data. can i revert back to my table to older data with help of log file or anything.

    With regards,
    Sathish.S
  2. satya Moderator

    Certainly, you can use LUMIGENT's LOG EXPLORER to read the transaction log and obtain those DDLs and apply back to the database. Get familiar with this product before you accomplish the recovery action.

    HTH

    Satya SKJ
  3. bradmcgehee New Member

    Other than a tool like Log Explorer, I don't know of any other options to roll back data from a log. You can download a free trial copy of Log Explorer fromhttp://www.lumigent.com and give it a try, but as satya says, take your time using it as it does have a little bit of a learning curve.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page