SQL Server 2019 on Linux数据库修复  硬盘故障导致数据库恢复失败  SQL Server数据库页面损坏故障修复

客户名称: 某新能源公司

数据类型: SQL Server 2019 on Linux

数据库大小: 121 GB

故障检测: 硬盘故障导致SQL Server数据库恢复失败，数据库无法访问。重启SQL Server服务器依然无法解决问题。

故障分析：

ERRORLOG显示数据库页面2538730损坏：

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x464ff469; actual: 0x48a7f5a1). It occurred during a read of page (1:2538730) in database ID 5 at offset 0x000004d79d4000 in file '/var/opt/mssql/data/realxxxxx.mdf'.  Additional messages in the SQL Server error log or operating system error 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.

数据库自动恢复报错：

Error: 3313, Severity: 21, State: 5.

During redoing of a logged operation in database 'realxxxxx' (page (1:2538730) if any), an error occurred at log record ID (22047:85072:18). Typically, the specific failure is previously logged as an error in the operating system error log. Restore the database from a full backup, or repair the database.

Error: 3414, Severity: 21, State: 4.

An error occurred during recovery, preventing the database 'realxxxxx' (5:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

从Linux服务器下载数据库mdf和ldf文件：

使用北京雨翰数据恢复公司自研的SQL Server数据库恢复工具将数据库所有对象包括用户表、视图、触发器、存储过程、外键约束、用户和组等导出至新数据库中。

修复结果: 数据恢复率达100% 客户验证没有问题。