May 12 2022 02:50 AM
get this error after select script
"SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x1004cd6e). It occurred during a read of page (1:1520237) in database ID 137 at offset 0x000002e64da000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER2014\MSSQL\DATA\COMDAT.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."
what could cause this and how can i fix it?
May 13 2022 02:49 PM
May 29 2023 11:53 PM - edited Jun 01 2023 03:21 AM
The main cause behind the corruption is logical consistency for this error for the SQL server.
This error comes when the Database file has been corrupted.
For this, you can follow the steps for fixing the database through this:
https://community.spiceworks.com/how_to/190952-how-to-troubleshoot-database-consistency-errors-repor...
I hope this would help.