Questions

How to repair backup of .mdf file database?

+
1 Votes

How to repair backup of .mdf file database?

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?

Member Answers

+
1 Votes
Enriquemallon
Collapse -

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

+
1 Votes
teven6hutchinson
Collapse -

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.

+
0 Votes
benzimat
Collapse -

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.

+
0 Votes
benparker
Collapse -

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

+
0 Votes
shinjijong
Collapse -

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

+
0 Votes
Bassiel
Collapse -

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

+
0 Votes
HelenGraves
Collapse -

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

+
0 Votes
PeterC.Johnson
Collapse -

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

+
0 Votes
johan.mark25
Collapse -

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/