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.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

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

Collapse -

Repair backup of .mdf file database

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

This will help you, check this out : http://www.recoveryfix.com/sqldatabaserecovery.html

---------------------------------------------------------------------------------------------------------
Custom Software Development Company
http://www.pyxle.ca/services/software-development

Collapse -

MDF file recovery software

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

you can get backup of corrupt .MDF file with Kernel for SQL Database Recovery Software. Software support multiple MDF file and also help to recover triggers, keys, indexes and stored procedures. Software can use in all SQL Server version.

Read more and download free trial version from - http://www.sqldatabaserecovery.org/

Back to Windows Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums