restoring a file to a DB once other files have been updated

• winston Smith

  SSCoach

  Points: 19500

  More actions

  June 19, 2008 at 7:08 am

  #381215

  lets say you have a database with 10 files.

  one file becomes corrupt and has to be restored. the dba doesnt notice this for some hours.

  when he goes to restore the file, it is now a few hours behind the other files. what if there are relationships between objects in files that have been modified since, and the file thats down for a number of hours?? does that mean the DBA will just have to restore the whole db to the point of failure of the file?

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  June 19, 2008 at 8:18 am

  #831130

  If he's not doing filegroup backups then he'll have to restore the entire DB and roll through the logs.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: