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
Last activity: May 13, 2021, 10:20 AM