Home » 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
  • September 26, 2015 at 1:14 pm #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?

    September 29, 2015 at 1:35 pm #766 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    Did you run DBCC CHECKDB?

    October 6, 2015 at 11:00 am #793 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

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

    October 7, 2015 at 12:50 pm #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.

    October 8, 2015 at 12:24 pm #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

    May 26, 2016 at 11:15 am #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.

    October 18, 2016 at 6:13 am #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

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