October 15, 2004 at 7:34 am
In my backup plan, I perform a transaction log backup every hour at 5 minutes past the hour. I perform a full and/or differential backup at 7:00 PM each night. If my transaction log backup tries to run while my full/diff backups are running, it just skips that run and tries again the next hour.
My question is about restoring.
If I have done a transaction log backup at 6:05 and then a full backup at 7:00 but I end up needing to restore to 6:30, is it possible? If I were to take the full backup from the previous night then apply all transaction log backups, would I be able to get to the 6:30 point in time?
I am not sure what happens to the transaction log when the full backup runs. Obviously, since my trans log backup won't run at 7:05 (because the full backup is running) I will end up having a trans log backup at 6:05 and again at 8:05. Will the 8:05 log backup have all transactions since 6:05 or will the full backup have truncated the data in the log from 6:05 to 7:00?
Thank you.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 15, 2004 at 9:30 am
Your 8:05 transaction backup will have transactions from after 6:05. If you need to restore to 6:30. Restore your db from the last db backup (in this case before 6:05). Then restore all of the transaction logs (including the 8:05) and specify a point-in-time restore of 6:30.
apf
October 15, 2004 at 9:31 am
Thank you for the clarification.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply