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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
So what do you think I am?