October 7, 2003 at 3:39 pm
I have a filegroup backup running each night at 3pm on production. This filegroup has the high transaction tables. My transaction log backups run every 2 hours. If I have to get to the data to a point in time, say 7am, would I able to do it with the filegroup backup and the log backups alone or do I need to restore the full backup first?
October 8, 2003 at 7:22 am
No, as long as you've got the complete sequence of tran log backups covering the filegroup backups, you do not need to start with a full database backup.
E.g., if you have two filegroups and back each up on alternate nights, you need to restore the one from two nights ago, the one from last night, and then all the tran log backups starting with the last before the first restored backup (i.e. two nights ago) and ending with the one containing the PiT you're restoring to.
--Jonathan
--Jonathan
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply