Restore Multiple pages
-
for a single page to restore it is:
RESTORE DATABASE database PAGE='1:189'
FROM DISK='path'
GO
How do you restore multiple pages if you have corruption in multiple pages?
-
Or is it that you can restore multiple pages this way:
RESTORE DATABASE database PAGE='1:189'
FROM DISK='path'
GO
RESTORE DATABASE database PAGE='1:190'
FROM DISK='path'
GO
RESTORE DATABASE database PAGE='1:191'
FROM DISK='path'
GO
and then restore a transaction log?
-
RESTORE DATABASE database PAGE='1:189, 1:190, 1:191'FROM DISK='path'GOThe maximum number of pages that may be restored in a single restore statement is 1000. See the page in Books Online titled "Performing Page Restores"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Great ! thanks a lot Gail
-
hi,
i've doubt how can i detect that the particular page is corrupted.
-
That's what CheckDB's there for. Preferably run regularly.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
vrabhadram (4/6/2009)
hi,i've doubt how can i detect that the particular page is corrupted.
By running regular DBCC commands as part of your maintenance plan.
You could also check suspect_pages table in the msdb database, each row represents a suspect page
-
Krishna Potlakayala (4/7/2009)
You could also check suspect_pages table in the msdb database, each row represents a suspect pageYes, but that assumes that SQL's encountered the suspect page. If checkDB is never run, it may be weeks or months after the corruption occurred that a query encounters the bad page and writes into suspect_pages. By that time the preferred methods of corruption won't be an option because last clean backup is far too old to restore from.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply