{"id":1032,"date":"2008-08-11T19:32:00","date_gmt":"2008-08-11T19:32:00","guid":{"rendered":"\/blogs\/paul\/post\/Search-Engine-QA-22-Can-all-page-types-be-single-page-restored.aspx"},"modified":"2013-01-27T09:20:35","modified_gmt":"2013-01-27T17:20:35","slug":"search-engine-qa-22-can-all-page-types-be-single-page-restored","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-22-can-all-page-types-be-single-page-restored\/","title":{"rendered":"Search Engine Q&A #22: Can all page types be single-page restored?"},"content":{"rendered":"

<\/p>\n

\nI've had a few follow-ups on my two posts about boot page<\/a> and file header page<\/a> corruption – asking if its possible to do single-page restore operations for these pages. Let's try:\n<\/p>\n

\n

\n\tCREATE DATABASE BootPageTest;
\n\tGO <\/font>\n\t<\/p>\n

\n\t— Single page restore is only possible using the FULL recovery model
\n\tALTER DATABASE BootPageTest SET RECOVERY FULL;
\n\tGO <\/font>\n\t<\/p>\n

\n\tBACKUP DATABASE BootPageTest TO DISK = 'C:sqlskillsBootPageTest.bck';
\n\tGO
\n\tBACKUP LOG BootPageTest TO DISK = 'C:sqlskillsBootPageTest.trn';
\n\tGO <\/font>\n\t<\/p>\n

\n\tRESTORE DATABASE BootPageTest PAGE = '1:9' FROM DISK = 'C:sqlskillsBootPageTest.bck';
\n\tGO <\/font>\n\t<\/p>\n

\n\tMsg 3111, Level 16, State 1, Line 2
\n\tPage (1:9) is a control page which cannot be restored in isolation. To repair this page, the entire file must be restored.
\n\tMsg 3013, Level 16, State 1, Line 2
\n\tRESTORE DATABASE is terminating abnormally. <\/font>\n\t<\/p>\n<\/blockquote>\n

\nThe answer is no. The following page types cannot be restored using single-page restore:<\/font>\n<\/p>\n