October 26, 2011 at 1:38 am
Hi,
I have read on internet that if any page is corrupt in database then we have to restore that page from full database backup then we need to restore the latest differential backup then all subsequent transaction log backup. Is this the way to restore corrupt page in database ?
Thanks in advance.
October 26, 2011 at 1:52 am
This article may give you a starting point:
October 26, 2011 at 7:27 am
beejug1983 (10/26/2011)
Hi,I have read on internet that if any page is corrupt in database then we have to restore that page from full database backup then we need to restore the latest differential backup then all subsequent transaction log backup. Is this the way to restore corrupt page in database ?
Yes, Page restores are done in that sequence.
October 26, 2011 at 7:43 am
Chapter 8 of SQL Server MVP Deep Dives 2. </shameless plug>
What you have there is not quite the process.
Enterprise edition:
Restore page from full
Optionally restore diff
Restore logs in sequence
Take a log backup
Restore that log backup WITH RECOVERY
Standard and lower
Take a log backup WITH NORECOVERY
Restore page from full
Optionally restore diff
Restore logs in sequence
Restore the log backup taken at the start WITH RECOVERY
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2011 at 7:46 am
BrainDonor (10/26/2011)
GilaMonster (10/26/2011)
Chapter 8 of SQL Server MVP Deep Dives 2. </shameless plug>Two more weeks before Amazon in the UK have that. Not a happy bunny.
Available NOW
October 26, 2011 at 7:57 am
Available now over there, but not over here. By the time it was shipped over I could probably get it over here now and that also requires some additional effort on my part. Two more days until publication over here, apparently.
It feels like I ordered it months ago. Still picking bits out of the first book.
October 26, 2011 at 8:10 am
BrainDonor (10/26/2011)
Available now over there, but not over here. By the time it was shipped over I could probably get it over here now and that also requires some additional effort on my part. Two more days until publication over here, apparently.It feels like I ordered it months ago. Still picking bits out of the first book.
Ebook is instant download and AFAIK the link I gave you doesn't discriminate on location.
October 26, 2011 at 11:44 pm
Thanks all for useful comments.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply