Damage situation One:
SQL Server has returned an error 23 (data error (cyclic redundancy check) in the file Xx.mdf, where the offset is xxx, and the operating system has given SQL Servers a full database consistency check (DBCC CHECKDB)
--1. User mode is set to single usersp_dboption'dbname','Single user','true' --or--alter DATABASE dbname SET single_user2, run DBCC CHECKDB, or DBCC CHECKTABLEDBCCCHECKDB (Dbname,repair_allow_data_loss)--data is corrupted--or DBCC CHECKDB (ydgl,repair_rebuild)--data is corrupted--if you know which table is the problem, you may use the following UsedbnameDBCCchecktable (Spgjdetail,repair_allow_data_loss) UsedbnameDBCCchecktable (spgjdetail,repair_rebuild)--3. Set user mode to multi-usersp_dboption'dbname','Single user','false' --or alter DATABASE dbname SET Multi_user
How to handle database MDF file corruption