SQL server detects consistency-based logic I/O errors

After the SQL Server database is restored from the backup file. Bak and recovered, an error is reported during query: SQL server detects a consistency-based logic I/O error.

SQL server detects that the consistency-based logic I/O error checksum is incorrect (it should be 0xd4eae74b, but it is actually 0xd4eb674b ). In the file 'd: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data \ CCMs. this error occurs during the read operation on the page (1: 735) in Database ID 7 at the position of 0x000000005be000 in MDF. The SQL Server error log or other messages in the System Event Log may provide more details. This is a critical condition that threatens database integrity and must be corrected immediately. Perform a complete database consistency check (DBCC checkdb ). This error can be caused by many factors. For more information, see SQL Server books online.

Solution:

Refer to the connection help:
Create a query and execute:
Use CCMs -- CCMs is the database name

Go

Alter database CCMs set single_user

DBCC checkdb (CCMS, repair_allow_data_loss) with no_infomsgs

Go

Alter database CCMs set multi_user

Go
Solution !!