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:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Sir,
How i get the latest Differential backup/log file number from the backup file. How i get this number through vb program..

Unnikrishnan 3/18/2004 4:29:56 AM


You must log on before posting a comment.

Are you a new visitor? Register Here