July 25, 2009 at 2:03 am
How can i fix this error?
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:9; actual 0:1036). It occured during a read page (1:9) in database ID 7 at offset 0x00000000012000 in file blah... blah... blah..
July 25, 2009 at 2:22 am
How did the database get detached?
Do you have a backup?
The recommended solution here is to restore from a clean backup. If you have no backup (why?) then we're going to have to hack the DB back into the server, as a corrupt database cannot be attached.
Create a new database with the same number of files as the one you're trying to attach, the same number of filegroups, the same names for the logical files.
Stop SQL.
Delete the files for the database you've just created and replace them with the files for the database you're trying to attach
Restart SQL.
Once SQL comes up, check the status of the database and post back here. There's more work that we need to do to get this thing fixed, if we can get it fixed at all. The damaged page looks like it'll be one of the critical system pages and, if it is, there won't be any fix.
Again, if you have clean backups, restore them.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply