I am working on SQL Server 2014 and getting Error: 823, Severity: 24, State: 2rnI/O error (bad page ID) detected during read at offset 0x00000000fac000 in file 'd:\mssql\MSSQL\data\master. mdf'. rnhow to troubleshoot this error?
How to Fix SQL Server Error 823?
Resolved
SQL
CM
Community Member September 26, 2015
6 replies
519 views
Reviewed by moderators
6 Answers
Did you run DBCC CHECKDB?
Yes, I did run the DBCC CHECKD, but it still giving me SQL error 823.
Try to restore a backup to another server and do some disk checks on your primary machine.
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
If you are able to shut SQL down, you could try running chkdsk to see if there are other issues on the disk.
Please go through this article it might be helpful for you: http://www. sqlrecoverytool. com/fix-sql-server-fatal-error-823. html