Home Dashboard Directory Help
Search

Allow Page Level Restore in Simple Recovery mode if the page is in an unchanged extent by J. Granden


Status: 

Closed
 as By Design Help for as By Design


1
1
Sign in
to vote
Type: Suggestion
ID: 771131
Opened: 11/14/2012 2:53:16 PM
Access Restriction: Public
0
Workaround(s)
view

Description

R/W Databases in Simple recovery do not allow page level restore.

Assume some data corruption happened on disk that affects 1 page. If the DB is otherwise logically consistent, and the extent it's has not been modified, then it should be possible to restore the corrupt page from the most recent full backup.

Details
Sign in to post a comment.
Posted by Microsoft on 2/8/2013 at 9:43 AM
Thank you for your feedback. Unfortunately, this is a fairly uncommon case, and would require much analysis to make sure that there was no possibility of causing logical corruption by restoring a page that was out of sync with the rest of the database. Furthermore, we have no way to ensure that the page coming from the backup is in sync with the rest of the database. It could be coming from a month-old backup, which would cause more problems.
Posted by Microsoft on 2/7/2013 at 10:05 AM
Thank you for your feedback.
Unfortunately, this is a fairly uncommon case, and would require much analysis to make sure that there was no possibility of causing logical corruption by restoring a page that was out of sync with the rest of the database.
Furthermore, we have no way to ensure that the page coming from the backup is in sync with the rest of the database. It could be coming from a month-old backup, which would cause more problems.
Sign in to post a workaround.