SQL Server detected a consistency-based logical I/O error

Background: Create a new DB_GZN recovery database backup file

Execution: SELECT * from VI_MPS_PAPLT

Error message:

MSG 824, Level 24, State 2, line 2nd SQL Server detected a consistency-based logical I/O error checksum is incorrect (should be: 0x20d61048, but actually: 0x7a8ab3ae). In the file ' C:/Program files/microsoft SQL server/mssql10. This error occurs during the reading of the page (1:9,397) in database ID 13, where the offset is 0x0000000496a000 in Mssqlserver/mssql/data/db_gzn.mdf '. Additional messages in the SQL Server error log or the system event log may provide more detailed information. This is a serious error condition that threatens the integrity of the database and must be corrected immediately. Please perform a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; For more information, see SQL Server Books Online.

Repair process:

1.ALTER DATABASE DB_GZN Set Single_user--set to single user

Go

2.DBCC CHECKDB (DB_GZN, Repair_allow_data_loss) with NO_INFOMSGS--Allow data loss

Go

3.ALTER DATABASE DB_GZN Set Multi_user--set to multi-user

Go

Execution Result: fix

To perform a process tip:

SQL Server detected a consistency-based logical I/O error