SQL database page level corruption

30 pts.
Tags:
SQL
SQL Database
SQL Server
Hello Experts,

We are facing page level corruption in SQL database. The database size is 650 GB. What should we do?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check out this link for a good write up on troubleshooting and a fix.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Is there a new hardware inserted in the system? If yes, remove this one. Assuming you have taken the database backup of the original MDF and LDF files. Next try to run DBCC CHECKDB command which helps to fix the corruption issue in SQL database. Moreover it fixes the inconsistency in SQL server database by performing Database Consistency Checks.
    118,690 pointsBadges:
    report
  • ToddN2000
    Also found this write up on our servers help docs

    Resolving SQL Database Page Level Corruption

    Before starting the process take a full backup of the database files to keep yourself on a safer side if anything goes wrong. 
    Then follow the instructions below:

    Check the difference between an original and the corrupted file using a text comparison software.
    Execute DBCC CHECKDB command on the damaged file. This command performs a systematic data integrity check and identifies the issues.
    Now, execute DBCC PAGE command after switching on the trace flag 3604 (for this run DBCC TRACEON command). It will examine infected page content. 
    DBCC TRACEON (3604)

    DBCC PAGE ({ ‘dbname’ | dbid}, filenum, pagenum [, printopt={0|1|2|3}])

    Here, filenum and pagenum are page ids.

    Other parameters are defined below:

    0 - the header part of the page will be printed

    1 - SQL page header with per row hex dumps

    2 - Detailed page header with a full hex dump of the page

    3 - Description of per row interpretation of page header

    Now, run the command ‘SELECT * from dbo.tablename’. This command is for confirming the page number and.
    Now, you know the location where corruption has taken place. Use the text comparison software to compare it with original page.
    Finally, fix the corrupted page after detecting flaws from the previous step and then, execute the DBCC CHECKDB command on the restored file.
    113,720 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: