How To Fix SQL Database Error 824 ?

Dong Lam Trien

My data SQL Server is reported this error, How does this error fix you ?

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

During redoing of a logged operation in database 'MyData', an error occurred at log record ID (30182:834:13). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.

Could not open new database 'MyData'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 824)

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naresh Beniwal3y ago
https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-824-database-engine-error?view=sql-server-ver16
Mageshwaran R6y ago
Hi,
please refer this link:
https://www.data-recovery-solutions.com/blog/resolve-microsoft-sql-server-error-824/
Dong Lam Trien7y ago
I have read the pages your sent to me, these pages generally have not gone so far to solve the problem, I also tried it but still haven't fixed it.
error, the pages you send are mostly ads to sell their bug fix software them, I have not found the free error correction table
Amit Mohanty7y ago
Hey go through the below links:

https://www.sqlserverlogexplorer.com/sql-error-824/

https://www.stellarinfo.com/blog/troubleshoot-sql-database-error-824/

https://support.microsoft.com/en-in/help/2015756/how-to-troubleshoot-msg-824-in-sql-server

http://data-base-recovery.blogspot.com/2011/09/how-to-resolve-error-824-in-sql-server.html
Madan Shekar7y ago
The 824 error message usually indicates that there is a problem with underlying storage system or the hardware or a driver that is in the path of the I/O request. You can encounter this error when there are inconsistencies in the file system or if the database file is damaged.

https://www.data-recovery-solutions.com/blog/resolve-microsoft-sql-server-error-824/

go through above link for more info