copper_sunflower | SQLServerCentral

copper_sunflower

Forum Replies Created

Viewing post 1 (of 1 total)

RE: Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:16514; actual 0:0). It occurred during a read of page (1:16514) in database ID 8 at offset 0x00000008104000 in file 'G:\test\test.mdf'. Additional messages in the SQL Serve

Your database test.mdf is corrupt. If you have a backup, then just restore with that backup. If you don't, then you may use REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS parameters in DBCC CHeckdb...

August 20, 2014 at 9:10 pm

#1739756

Viewing post 1 (of 1 total)