How to repair backup of .mdf file database?

Tags:
.MDF files
MSSQL
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 ServerMSSQL.1MSSQLDATAMSDBData.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?

Software/Hardware used:
SQL Server

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi

You have no need to uninstall/reinstall  SQL Server. You will easily get back your MSDB database from the corrupted instance by the using of a third party utility.

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 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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry

    What happens when you run DBCC CHECKDB on the msdb database? Can you post the full output? Do you know what object that page is associated with?

    Do you have a backup of the msdb database that you can restore?

    Worst case you can just take the backup from another server's MSDB database but you'll need to script out all the jobs on this server so that you can put them back. Same goes for things like operators, SSIS packages, etc. as those are all stored in the msdb database.

    66,280 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following