Forum Discussion

lincolnburrows's avatar
11 years ago

How to eradicate Msg 824, Level 24, State 2, Line 1

I am getting this error while executing

"DBCC CheckDB('test') WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLOCK"

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 Server
please help me out with dis problem the database is in emergency mode. It is not getting recovered

 

Replies have been turned off for this discussion