Post reply

Databse restore problem if one of the middle transaction log backup file get deleted?

  • March 22, 2004 at 6:49 am

    #152082

    I have Full backup of 00:00 am and transaction log backups of every 15 mints and my 2:30 am transaction log file get deteled and then database get corrupt at  6 am. Up to what time I can recover my data. Is there any way so that I can recover my data  between 2:30 am to 6:00 am.

    --sntiwary

  • March 22, 2004 at 7:06 am

    #499748

    At what time was your last log backup?

  • March 22, 2004 at 7:53 am

    #499756

    I have all the Transaction log backup files till 6 am except the one file of at 2:30 AM.

    -sntiwary

  • March 23, 2004 at 10:15 am

    #500068

    You have to restore the full backup and apply logs until 2:30. You can not apply next logs after a missing one

    R

     

Viewing 4 posts - 1 through 3 (of 3 total)

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