how to fix sql server page level corruption?

database, database-administration, sql, sql-server

Solution

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')

Problem

Original source