Restore Database Corrupt Page 1

[Skittle]

Found an interesting section in my SQL Server 2005 70-431 book.

A single corrupt database page can cause the entire database to go offline. You can restore an individual corrupt page by restoring the page from the last full backup using the following syntax:-

RESTORE DATABASE MyDb PAGE = '1:88'
FROM DISK = ‘C:\MyBack.bak’
WITH NORECOVERY

My question is, can anybody explain to me the '1:88'?
If I have a corrupt page, how do I specify it using this
'n:nn' syntax?

Dazed and confused

 

[mrdenny]

That is the address of the corrupt page. When you do the DBCC CHECKDB and it tells you that you have a corrupt page it gives you the page address that is corrupt. Use that page information to go the restore.



Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com