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
扫描雨翰数据恢复官方微信获取专业数据库恢复服务