Skip to main content

Posts

Showing posts with the label error 23 Data error cyclic redundancy check in sql

error 23 Data error cyclic redundancy check in sql on Database

What to do if following type of error comes in eventlog during sales order posting in axapta? The operating system returned error 23(Data error (cyclic redundancy check).) to SQL Server during a read at offset 0x00001ef1832000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\axdb1.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level 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. I tried DBCC CHECKDB but problem did not resolved Then I tried to resynchronize database and AOT but still problem exist. When I restore database then problem resolved . Is there any  other way on which we could resolve this issue. Your comments are welcome.