北京雨翰数据库恢复热线: 400-166-9190/13811580958(微信)
7 x 24 在线支持!国内领先的专业数据库恢复公司!

客户案例

相关案例

SQL Server 2019 on Linux 硬盘故障导致数据库恢复失败,数据库损坏修复,SQL Server数据库恢复
发布时间:2024-05-02

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数据库恢复。
电话:13811580958(微信),QQ:289965371
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 13811580958
Wechat: 13811580958
Email: 289965371@qq.com
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

咨询热线:

400-166-9190

13811580958

返回顶部
在线咨询