how to fix sql server page level corruption? [closed]

Question

How can i fix the page level corruption in sql database. I am facing a big issue related to this. Can anyone help me.

Answer 1

1. 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.

2. Run this Query to Change DB into Single User Mode

   • ALTER DATABASE corrupted_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE

3. 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)

  4. Once this Execution Completed Sql returns “Errors are Corrected”

  5. Run this Query to Change the DB into Multi-User Mode

• ALTER DATABASE Application Manager SET MULTI_USER

  6. 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.

  7. Now Run DBCC CHECKDB('Your DB')