Wise man or Wise guy? You Decide

Just another WordPress.com weblog

Archive for the ‘Recovery’ Category

Page Restores

Posted by sqlwiseguy on August 12, 2008

This is just a short post about something I just learned. You can restore a single page of your database. I learned about this in this post, Search Engine Q&A #22: Can all page types be single-page restored?, by Paul Randall on his In Recovery blog. The basic syntax is:

Restore Database Test Page = ‘2:10’ From Disk = ‘C:\Backups\Test.bak’

I’m not sure what the practical use of this is, as doing a full database restore will obviously restore any pages that might be corrupted. You need to search a little to find some good documentation in BOL, so here is a link to the documentation, Performing Page Restores.

If you have ever used page restore let me know why and how it worked for you.

Advertisements

Posted in Recovery, SQL Server | Leave a Comment »