SQL Server Alert Error 825

Question

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

Answer 1

Hello,

Based on the information you provided, I suggest you try to open cmd as an administrator and run the following command to check whether the problem disk has file system structure damage (replace the D drive letter in the command line below with the drive letter of the actual problem disk):

Chkdsk D:

If the problem is caused by a physical disk or related disk driver problem, I suggest you contact the disk manufacturer as soon as possible to resolve the problem.

I suggest you refer to the following link:

MSSQLSERVER_825 - SQL Server | Microsoft Learn

Best Regards

Zunhui