August 21, 2002 09:21 PM
Restoring After Isolated Disk Failure
Rating:

(0)
SQL Server Magazine
InstantDoc ID #26067
One of the biggest benefits of using the file and filegroup backup strategy is the ability to recover quickly from isolated disk failures. If only one file or filegroup is damaged, you can easily recover by restoring only the damaged files or filegroups.
Using the case study from the main article, imagine that only file PubsTestRWFile2 has been damaged. In this case, the database is suspect but most of the database files are still accessible. To recover up to the time of the failure, you proceed very much like you do with the whole database recovery, except you need to look at only one file: the damaged PubsTestRWFile2.
Howev...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: