Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: Retreiving Lost Data

    I Somehow restored the latest database onto the test database. Can I now retrieve the lost data. If Yes , How is it possible.

    Akash

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Lost Data

    If you're backing up Transaction Logs, you should be able to restore the Transaction Log. Research the help on restoring Transaction Logs. You should set up a schedule to backup Tran Logs if you don't already have one. I backup Tran logs every hour.

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    If you don't have backups to restore from though, you lost everything and cannot retrieve it.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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