September 11, 2012 at 9:44 am
I've read about filegroup restores but have reservations about using this instead of Full restores. How is referencial integraty between the tables in the file group and tables in other filesgroups ensured?
September 11, 2012 at 10:05 am
When restoring from filegroups you need to also have all the tlog backups, spanning the entire time/date range of your files.
September 11, 2012 at 10:10 am
Just to expand on the above... the transaction logs are also applied during the filegroup restore which ensures database consistency. I do not believe a filegroup restore can be completed without doing this.
September 11, 2012 at 10:38 am
It sounds like the scenario in which you would do this would be if the disk containing the filegroup (but not all the other filegroups) is lost. The transaction log backups would restore it to the most recent available state. If you are restoring due to accidental deletion of data or other referencial corruption, you'd want to stop restoring tansaction log backups at the point just before the problem you're trying to fix, then I'd still worry about orphan records in the restored filegroup or elsewhere.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply