Failed: 23(Data error (cyclic redundancy check).)


#1

During the backup process you can receive the following error message:

DETAILED LOG:
10/18/2016 12:00:19 AM Creating backup of Data16 to C:\Windows\TEMP (full)
10/18/2016 12:00:32 AM ERROR: Read on “C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\Data16.MDF” failed: 23(Data error (cyclic redundancy check).)
BACKUP DATABASE is terminating abnormally.
10/18/2016 12:00:32 AM ERROR: Job finished (With Errors)

Here is the solution:

Looks like there are inconsistencies on the backup file. A RESTORE VERIFYONLY on the backup file should tell you whether the backup is in a consistent state. If not, then we would strongly suggest to run a checkdb on the source database on which the backup was done. If the CHECKDB output comes back clean, then we would suggest that you take a backup again and try restoring it. Additionally, perform a quick health check on the disk on which the backup files are stored. In case CHECKDB doesn’t come back clean, then you need to check the level of corruption and take decisions based on that. If the errors cannot be repaired, then we would suggest a point-in-time recovery of the source database (if such an option exists). Do not run REPAIR ALLOW DATA LOSS on the database.

Please find more information at: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/d779d68b-1619-47ca-917a-d89f683dd428