Post reply

Urgent: Dont have the log backup

  • April 30, 2004 at 5:03 pm

    #152130

    Hi everyone,

    I have a backup of my database on 4/16/2004.  On 4/18/2004 there was a log backup but since I wasn't here, I did not remove the tape.  The tape was overwritten the next day.  I need to restore the database to 4/21/2004.  Can I backup the logs of that database now and apply it after restoring the full backup of 4/16/2004?  Thank you very much in advance!

  • May 2, 2004 at 11:58 pm

    #504948

    Shahgols,

    I think you can only restore your full backup.  Backing up the log now will not work as you are missing all the transactions that occured between the 4/16/2004 and 4/18/2004.  Unless you have a full backup that occured AFTER the log backup on tape was overwritten, you cannot restore to point in time.  Your only choice will be to restore your last full backup.

    Angela

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply