October 20, 2006 at 2:40 pm
Help me with this scenario:
For simplicity in this example:
Transaction Log Backups occur at 6:00 PM every day.
FileGroup1 is backed up every Monday at 10:00 PM
FileGroup2 is backed up every Thursday at 10:00 PM
Data gets corrupted on Friday in FileGroup1.
How do I restore?
1) save tail end of transaction log
2) Restore FileGroup1
Now what? Do I roll forward transactions logs from Tues, Wed, Thur, Fri, plus tail?
This seems like the right thing but won't that cause problem with the data on FileGroup2 as any data from the rolled forward trans logs would already be committed.
Bob McC
October 23, 2006 at 8:00 am
This was removed by the editor as SPAM
October 23, 2006 at 2:28 pm
You restore the filegroup that you need to restore then all the logs after that filegroup backup. If you don't have a tlog to restore you cannot complete the file group restore. The transaction logs are used to make sure data is consistant accross all file groups even if data hasn't changed in them you must have one tlog to bring the db back on line!
Wes
Help me with this scenario:
For simplicity in this example:
Transaction Log Backups occur at 6:00 PM every day.
FileGroup1 is backed up every Monday at 10:00 PM
FileGroup2 is backed up every Thursday at 10:00 PM
Data gets corrupted on Friday in FileGroup1.
How do I restore?
1) save tail end of transaction log
2) Restore FileGroup1
Now what? Do I roll forward transactions logs from Tues, Wed, Thur, Fri, plus tail?
This seems like the right thing but won't that cause problem with the data on FileGroup2 as any data from the rolled forward trans logs would already be committed.
Bob McC
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply