Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    28

    Unanswered: how to restore specific records

    Scenerio:
    Its 3pm and a user comes to me and says, she's deleted an invoice with many associated items. I know the affected tables (foreign keys) and I have last nights backup of the db. However I don't want restore the entire db back from last night just the deleted invoice record/s. What is the best practice procedure for accomplishing this?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    If you have Log Explorer, you can attach to live trx log and generate the UNDO statements. If not, - restore the database to a different name. Then either manually, or with SQLDataCompare generate the difference scripts.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    May 2004
    Posts
    28
    Quote Originally Posted by rdjabarov
    If you have Log Explorer, you can attach to live trx log and generate the UNDO statements.
    How can one tell if he has Log Explorer? I'm using SQL Server v7.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •