May 9, 2008 at 6:49 am
lets say i have a DB with 3 fileGroups, each with 3 files.
Filegroup a, b and c.
there is an issue with the data in filegroupc, datafile1, however the issue is not discovered for many hours. when it is discovered, the db admin decides to restore just the problematic file.
the only backup he has for the file is 10 hours old.
my question is , even though the database continued to function after an issue occroured, can you restore an old file into a database that has been active for many hours after the backup was taken ?
May 9, 2008 at 9:39 am
It depends on whether or not the data in the filegroup changed and how that affects the rest of the database. It's possible to restore the file and cause issues because of rows that caused issues. Maybe you have related tables that aren't explicitly related.
That make sense?
May 9, 2008 at 10:58 am
yea, it does. im not having a problem, im just playing around with backups as i had a few spare minutes and this question kept bugging me. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply