cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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