Sep 20 2024 02:58 PM
We started getting below SQL Server 823 Error alerts on 3 databases.
SQL Server Alert System: 'Error825' occurred on
A read of the file 'c:\mdf\SAmpleDB.mdf' at offset 0x00000728018000 succeeded after failing 1 time(s) with error: 23(Data error (cyclic redundancy check).). Additional messages in the SQL Server error log and operating system error log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Our Full Backups & Diff backups are also failing with 'Msg 3203, Level 16, State 1, Line 1. Read on 'D:\mdf\SAmpleDB.mdf failed: 23(Data error (cyclic redundancy check)
Msg 2013, level 16, state 1. BACKUP Database is terminating abnormally
We can see The device, \Device\Harddisk0\DR0, has a bad block error in eventvwr
However, DBCC CheckDB is succeeding.
These 3 databases are huge & are actually Publication databases in Transaction Replication setup.
Is there any way to fix this issue & keep DBs healthy without impacting Transaction Replication setup