How to repair backup of .mdf file database?

Question

Hi folks,

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?

Answer 1

Best Answer

Answer by jkabe · Jul 01, 2014 at 11:35 PM

The MDF files of SQL database may get corrupt due to some problem in the database. If such a situation arises, the user can use the software which recovers the lost MDF file. But before choosing the software, make sure that it is efficient enough to recover the unique keys, primary keys, indexes, stored procedures, views etc from your corrupt MDF file.

You can try this application to repaie sql database http://www.sqlserver.fixtoolbox.com/ use free demo version of SQL Server Fix Toolbox

Comments Locked · Share

Answer 2

Answer by Johnbrad · Feb 11, 2015 at 08:47 AM

Another better solution for repairing corrupted SQL Server database (MDB) files is by MS SQL Database Recovery Tool. This tool can fix any level of corruption, i.e. minor or severe, from SQL Server database files and recover maximum possible data from them. It also supports recovery of NDF files and saves recovered data in SQL database format or SQL scripts. Users are allowed to check the preview of recovered data before saving them. I would like to recommend all the users to try its free demo version first to check your recovered data.

To know more about this tool and to download its free demo version, you may visit: http://repairandmanage.blogspot.in/2014/06/sql-server-recovery.html

Comments Locked · Share

Answer 3

Answer by ankemercy · May 19, 2015 at 11:24 AM

Hello, For an instant solution to repair or recover damaged MDF files of SQL Database, you should try to take a help of nay professional SQL Recovery software for an absolute result. I would like to recommend RecoveryFix for SQL Database, which can be downloaded as a free trial from here http://www.en.repairsqlserver.net/

Comments Locked · Share

Answer 4

Answer by enriquemallon · May 28, 2015 at 06:54 AM

Firstly you should run DBCC CHECKDB('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS and checkout the error logs but some of the cases this technique fails to recover so we recommended you SQL backup recovery tool. As it is the secure and safe way to recover SQL database backup must utilize it is free to try from here:- http://www.sqlrepairtool.org/sql-server-backup-restore-software.html

Comments Locked · Share

Answer 5

Answer by danalott · May 29, 2015 at 05:46 AM

Recovers the overall existing SQL database objects like Table, Triggers, Stored Procedure, Views, Rules and XML data types also. The software is well capable to recover the XML data file which are human readable, making it easy to understand how data is interpreted during bulk operations and support with all kind of MS SQL server versions.

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

Comments Locked · Share

How to repair backup of .mdf file database?

9 Replies

Welcome to Unity Answers

Follow this Question

Related Questions