Error 823 may occur due to either SQL Server database corruption or I/O errors in the database. The error usually indicates that that there are some inconsistency in file system or the database file is corrupt.
To resolve the issues, you can use any of the below methods:
Method 1: Run Chkdsk to find file system inconsistency issues and resolve it. Method 2: Use DBCC CHECKDB utility to try repairing the damaged database.