how to fix sql server page level corruption? [closed]
Go to SQL Server Management Studio
Select the DB
Right Click the DB
Go to Properties
Select Options
Under Other Option select the Page Verify
Select as NONE.
Run this Query to Change DB into Single User Mode
- ALTER DATABASE corrupted_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Run this Query to Recover the Table/DB.
- DBCC CheckTable ('corrupted_table', REPAIR_ALLOW_DATA_LOSS)
(OR)
DBCC CheckDB ('corrupted_db', REPAIR_ALLOW_DATA_LOSS)
Once this Execution Completed Sql returns “Errors are Corrected”
Run this Query to Change the DB into Multi-User Mode
ALTER DATABASE Application Manager SET MULTI_USER
- Go to SQL Server Management Studio
Select the DB
Right Click the DB
Go to Properties
Select Options
Under Other Option select the Page Verify
Select the Option CHECKSUM.
- Now Run DBCC CHECKDB('Your DB')