Home » Blog » Topic » How to fix SQL server error 823?

How to fix SQL server error 823?

Lincoln Burrows ~ Modified: September 26th, 2015 ~ ~ 1 Minute Reading

Home Forums How to fix SQL server error 823?

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #761 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    I am working on SQL Server 2014 and getting Error: 823, Severity: 24, State: 2
    I/O error (bad page ID) detected during read at offset 0x00000000fac000 in file ‘d:\mssql\MSSQL\data\master.mdf’.
    how to troubleshoot this error?

    #766 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    Did you run DBCC CHECKDB?

    #793 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Yes, I did run the DBCC CHECKD, but it still giving me SQL error 823.

    #799 Score: 0
    Stephen West
    Moderator
    4 pts

    Try to restore a backup to another server and do some disk checks on your primary machine.

    #820 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    Sometimes due to high page level corruption the DBCC CHECKDB command declined to repair the SQL database and shows regularity failure error. So if you have a good backup, then restore it otherwise in this condition to resolve it the use of external agent is more admirable

    #2110 Score: 0
    Henry Davidson
    Moderator
    31 pts

    If you are able to shut SQL down, you could try running chkdsk to see if there are other issues on the disk.

    #3613 Score: 0
    Stephen West
    Moderator
    4 pts

    Please go through this article it might be helpful for you: http://www.sqlrecoverytool.com/fix-sql-server-fatal-error-823.html

Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.