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

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
1
Sign in
to vote
ID 771131 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 11/14/2012 2:53:16 PM
Access Restriction Public

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.

Sign in to post a comment.
Posted by Kevin [MSFT] 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 Kevin [MSFT] 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.