Corrupt table in database

Occasional Visitor

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?

1 Reply
Hi Tiyanjana,
The causes of this issue could be
1- file system corruption
2- hardware system issues including storage, SAN, disk, raid controller, etc.
3- driver issues
4- corrupted memory pages
5- problems with the SQL Server Engine.
For fixing it, you can use the steps in this Microsoft article: