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% 客户验证没有问题。

-----------------------------------------------------------------------------------------------------------
提供7*24专业SQL Server数据库修复，MySQL数据库修复，Sybase数据库远程及现场技术支持，Sybase ASE及Sybase SQL Anywhere数据库修复服务，Oracle数据库修复，PostgreSQL数据库恢复。
电话：19391880109(微信)，QQ：548953365
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices. Contact us by
Phone: +86 19391880109
Wechat: 19391880109
Email: 548953365@qq.com
扫描雨翰数据恢复官方微信获取专业数据库恢复服务