October 25, 2011 at 4:08 am
Hi,
Boot page has been corrupted on the one of database on sql server 2005 server. so the database become un accessable and showing status as recovery pending .
To do basic analyse i tried to bring the database to the emergency mode to run checkdb command ,but could not. is it possible to bring to the database to emergency mode and then run DBCC checkdb on it ?
Error message:
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xeb3fb566; actual: 0x5e04b98).
It occurred during a read of page (1:9) in database ID 12 at offset 0x00000000012000 in file 'D:\SQL\Data\xxxxxxx.mdf'.
Thanks & Regards,
Sudhakar A.
October 25, 2011 at 4:43 am
Hi Sudhakar,
If boot page is corrupt, you cannot run DBCC CHECKDB or go to EMERGENCY mode.
You need to restore from a backup.
Check this post by Paul : http://www.sqlskills.com/blogs/paul/post/Search-Engine-QA-20-Boot-pages-and-boot-page-corruption.aspx
Vishal Gajjar
http://SqlAndMe.com
October 25, 2011 at 5:39 am
Restore from backup. This is not repairable in any way.
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
November 3, 2011 at 5:42 am
Is page restore possbile here ?
November 3, 2011 at 6:44 am
No. Restore the entire database from backup.
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
November 13, 2011 at 11:12 pm
Thanks for you answer's.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply