Question

Locked

How to repair backup of .mdf file database?

By jordan26henderson ·
One of our clients gets the following error when trying to backup a database:


quote:
________________________________________
System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error:
incorrect checksum (expected: 0x121db60d; actual: 0x521db60d).
It occurred during a read of page (1:1632) in database ID 4 at offset 0x00000000cc0000 in file
'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf'.
Additional messages in the SQL Server error log or system event 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.
Could not insert a backup or restore history/detail record in the msdb database.
This may indicate a problem with the msdb database.
The backup/restore operation was still successful.
________________________________________


I tried to perform checkdb, checkdb repair_rebuild as well as checkdb REPAIR_ALLOW_DATA_LOSS but none of these corrected the issues is the MSDB database.

My question is: can I just grab a clean MSDB database from another instance to recover corrupt one or do I really have to uninstall/reinstall SQL Server?

This conversation is currently closed to new comments.

13 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Perform distortion less SQL MDF file backup recovery in easy and simple way

by Enriquemallon In reply to How to repair backup of . ...

No there is no need to uninstall/ reinstall SQL Server. You can simply grab a previous MSDB database from the corrupted instance immediately with the help of external agent.
Backup of SQL database MDF file is a crucial aspect in term of company legacy. So the way to recover SQL MDF backup must efficient and robust which very beneficial for data integrity. The use of SQL backup recovery software is a reliable and distortion less which gives you expected and desirable results.
Go through this for recovering SQL database backup: - http://www.sqlrepairtool.org/sql-server-backup-restore-software.html

Collapse -

It can be made easier than usually

by teven6hutchinson In reply to How to repair backup of . ...

Hi,

You may try third party solution SQL Server Fix Toolbox

I can suggest you a good manual solution that will help you repair your corrupt MDF file of SQL Server. DBCC CHECKDB and DBCC DBREPAIR statements have to be executed to perform repair operation.

The query statements and manual for software are given in this post: http://www.sqlserver.fixtoolbox.com/

Follow the steps given in this post and execute the DBCC CHECKDB and DBCC DBREPAIR statements as given in the post.

Thanks.

Collapse -

If you are facing any difficulty with project server after fully server cra

by benzimat In reply to How to repair backup of . ...

If you are facing any difficulty with project server after fully server crash, drive failures, fault in saved database, accidental file deletion, etc, then you can take help SQL Server Repair Toolbox of this http://www.sqlrepair.sqlserverrepairtoolbox.com/ tool can efficiently deal with all corruption issues and further restore entire project information, like project resources, task schedule, tasks, custom fields, etc from different project workspaces.

Collapse -

My Recommendation

by benparker In reply to How to repair backup of . ...

My pal's organization is in an urgent requirement of a solution for repairing their SQL database. So, I've been studying on SQL database for last 5 hours. I've found many different solutions so far. Currently I would go for SysInfoTools My SQL database Recovery as of now (confirmed after testing a demo version). Will share more relevant tools if I find further..
http://www.sysinfotools.com/recovery/ms-sql-database-recovery.html

Collapse -

Best Suggestion for you to repair and recover SQL server

by shinjijong In reply to How to repair backup of . ...

The solution only for facing SQL server errors and lost important database because SQL repair tool helps you to repair and recover SQL server database with complete data and support with all the MS SQL server version: Find the information here: http://www.sqlrepair.org/download-trial.html

Collapse -

Complete SQL Server Backup Recovery

by Bassiel In reply to How to repair backup of . ...

SQL Server is an application which contains some most important data and records which includes database files and its objects. Corruption leads to inaccessibility but now with teh help of advanced solution, you can easily repair and recover all the data. Read here for the solution -
http://repairandmanage.blogspot.in/2014/07/repair-bkf-file.html

Collapse -

Sql Recovery

by HelenGraves In reply to How to repair backup of . ...

Recover corrupt SQL database without any backup of MDF file. This is capable to repair corrupt MDF file & entire database of MDF and NDF files like tables, triggers, views, functions etc.

Try:- http://www.filesrecoverytool.com/sql-database-repair.html

Collapse -

sql database recovery

by PeterC.Johnson In reply to How to repair backup of . ...

SQL database Recovery software is the best and powerful software. This software repair damaged or corrupt SQL databases. The software can repair both the MDF and NDF SQL database files. For more information and free download click:- http://www.recoverydeletedfiles.com/sql-database-recovery-software.html

Collapse -

Free MDF file recovery Software

by johan.mark25 In reply to How to repair backup of . ...

MDF Repair Software is specially designed to recover corrupt and delete MDF file from corrupt SQL Database. you can recover multiple MDF file with this software. you can also use this software to recover keys, triggers, indexes, stored procedures etc. in few steps. for more features and get a free trial version visit - http://www.sql.mdfrepair.net/

Collapse -

Repair MDF File of SQL Database

by camrinjohn In reply to How to repair backup of . ...

Use RecoveryFix for SQL Database recovery software which is capable to repair corrupt or damaged SQL databases and restore recovered items.

Try demo version- http://www.recoveryfix.com/sqldatabaserecovery.html

Back to Windows Forum
13 total posts (Page 1 of 2)   01 | 02   Next

Operating Systems Forums