Sample Header Ad - 728x90

DBCC CHECKDB consistency-based I/O error

5 votes
4 answers
46180 views
Running: DBCC CHECKDB(DatabaseName) with NO_INFOMSGS gives me the following error: > Msg 824, Level 24, State 2, Line 1 > SQL Server detected a logical > consistency-based I/O error: incorrect pageid (expected 1:7753115; > actual 0:0). It occurred during a read of page (1:7753115) in database > ID 11 at offset 0x00000ec9b36000 in file 'K:\UAT > Databases\dbname.MDF'. Additional messages in the SQL Server error > log or system event log may provide more detail. This is a severe > error condition that threatens database integrity and must be > corrected immediately. Complete a full database consistency check > (DBCC CHECKDB). This error can be caused by many factors; for more > information, see SQL Server Books Online.' Also i found a entry in **dbo.suspect_pages** Please advise.
Asked by user3688698 (69 rep)
May 24, 2016, 02:33 PM
Last activity: May 13, 2021, 10:20 AM