Simply effective, which means wonderful. Thank you a lot, especially because otherwise I would have been unable to physically get the files I had to
Overview
Features
How to Recover
More Information
Related Products
Why DataNumen SQL Recovery?
#1 Recovery
Rate
10+ Million
Users
20+ years of
experience
100% Satisfaction
Guarantee
Recover Much More than Our Competitors
Recovery rate is the most important criterion of a SQL recovery product. Based on our comprehensive tests, DataNumen SQL Recovery has the best recovery rate, much more better than any other competitors in the market!
Average Recovery Rate
Learn more about how DataNumen SQL Recovery smokes the competition
Our Customers' Testimonials
Extremely Simple Interface
Recovery
Batch Recovery
Options
Solution for Following Common Errors and Problems in SQL Server MDF File
- xxx.mdf Is Not A Primary Database File
- xxx.mdf Is Not a Valid Database File Header
- Sql Server Detected A Logical Consistency-Based I/O Error: Incorrect Checksum
- Sql Server Detected A Logical Consistency-Based I/O Error: Torn Page
- Recover Delete Records or Tables in Database
Free downloadFor personal use
Buy NowFor businesses
Main Features in DataNumen SQL Recovery v4.5
- Support for Windows 95/98/ME/NT/2000/XP/Visa/7/8/8.1/10 and Windows Server 2003/2008/2012/2016.
- Support SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019.
- Support to recover the structure and data in the tables.
- Support to recover all data types, including XML type.
- Support to recover sparse column.
- Support to recover deleted records.
- Support to recover indexes.
- Support to recover views, triggers, rules and defaults.
- Support to recover stored procedures, scalar functions, inline table-valued functions and multistatement table-valued functions.
- Support to recover and decrypt encrypted objects.
- Support to recover multiple files, including MDF file and its associated NDF files.
- Support to output recovered data in MDF file or plain text file containing SQL statements that can reconstruct the database.
- Support to recover MDF/NDF data from undamaged or damaged VMWare VMDK(Virtual Machine Disk) files(*.vmdk), Virtual PC VHD(Virtual Hard Disk) files(*.vhd), Acronis True Image files(*.tib), Norton Ghost files(*.gho, *.v2i), Windows NTBackup files(*.bkf), ISO image files(*.iso) and Nero image files(*.nrg).
- Support to recover SQL Server data from temporary tempdb.mdf file.
- Support to recover MDF and NDF files as large as 16TB.
- Support to repair MDF files on corrupted media, such as floppy disks, Zip disks, CDROMs, etc.
- Support to repair a batch of MDF files.
- Integrated with Windows shell, so you can repair a MDF file with the context (right click) menu of Windows Explorer easily.
- Support drag & drop operation.
- Support command line (DOS prompt) parameters.
Free downloadFor personal use
Buy NowFor businesses
Using DataNumen SQL Recovery to Recover Corrupt SQL Server Databases
When your SQL Server mdf files are corrupt or damaged and you cannot open them normally, you can use DataNumen SQL Recovery to scan the mdf files and recover as much data from them as possible.
Start DataNumen SQL Recovery.
Note: Before recovering any corrupt or damaged mdf files with DataNumen SQL Recovery, please close any other applications that may modify the mdf files.
Select the corrupt or damaged mdf file to be repaired.
You can input the mdf filename directly or click the button to browse and select the file. You may also click the button to find the mdf file to be repaired on the local computer.
If there are one or multiple NDF files associated with the damaged MDF file, then you can add them as well:
If you know the format of the source damaged MDF file, then you can specify it:
If you do not specify the format, then by default, DataNumen SQL Recovery will try to analyse the source MDF file and determine the format automatically.
By default, DataNumen SQL Recovery will save the fixed mdf file into a new file named xxxx_fixed.mdf, where xxxx is the name of the source mdf file. For example, for source mdf file Damaged.mdf, the default name for the fixed file will be Damaged_fixed.mdf. If you want to use another name, then please select or set it accordingly:
You can input the fixed file name directly or click the button to browse and select the fixed file.
After the recovery process, you can start SQL Server Management Studio and access the corresponding recovered database.
You can also let DataNumen SQL Recovery output the fixed file as a .SQL file, as follows:
You can input the fixed file name directly or click the button to browse and select the fixed file.
.SQL file is a plain text file containing all the SQL statements that can be used to reconstruct the recovered database, including the database structure and data. After the recovery process, you can open it in SQL Server Management Studio and execute the SQL statements inside it to rebuild the database.
Click the button, and DataNumen SQL Recovery will start scanning and repairing the source mdf file. Progress bar
will indicate the recovery progress.
After the recovery process, if the source mdf file can be recovered successfully, you will see a message box like this:
Now you can access the recovered data:
1. If you choose to output the recovered data as a .MDF file, then you can start SQL Server Management Studio and access the data in the recovered mdf database.
2. If you choose to output the recovered data as a .SQL file, then you can open it in SQL Server Management Studio and execute the SQL statements inside it to rebuild the database.
More Information
DataNumen SQL Recovery 4.5 is released on April 25th, 2020
- Improve the recovery rate.
- Fix some bugs.
DataNumen SQL Recovery 4.4 is released on March 9th, 2020
- Support to recover XML data.
- Improve the recovery speed.
- Fix some bugs.
DataNumen SQL Recovery 4.3 is released on December 31th, 2019
- Improve the recovery rate.
- Fix some minor bugs.
DataNumen SQL Recovery 4.2 is released on September 8th, 2019
- Improve the recovery speed.
- Fix some minor bugs.
DataNumen SQL Recovery 4.1 is released on April 11th, 2019
- Redesign the batch recovery engine.
- Support to save batch recovery log.
- Fix some minor bugs.
DataNumen SQL Recovery 4.0 is released on December 8th, 2018
- Support to recover views, triggers, rules and defaults.
- Support to recover stored procedures, scalar functions, inline table-valued functions and multistatement table-valued functions.
- Support to recover and decrypt encrypted objects.
- Fix some bugs.
DataNumen SQL Recovery 3.2 is released on October 10th, 2018
- Support to recover indexes.
- Fix some bugs.
DataNumen SQL Recovery 3.0 is released on August 15th, 2018
- Improve the performance in processing huge data.
- Reduce the memory consumption in processing huge data.
- Fix some bugs.
DataNumen SQL Recovery 2.8 is released on March 6th, 2018
- Support SQL Server 2017
- Fix some bugs.
DataNumen SQL Recovery 2.7 is released on March 26th, 2017
- Support SQL Server 2016.
- Fix some minor bugs.
DataNumen SQL Recovery 2.6 is released on Feb 3rd, 2017
- Support to fix more database errors.
- Improve the performance.
- Fix some minor bugs.
DataNumen SQL Recovery 2.5 is released on February 12th, 2016
- Improve the recovery speed.
- Reduce the memory consumption.
- Fix some bugs.
DataNumen SQL Recovery 2.4 is released on October 1, 2014
- Improve the recovery speed.
- Fix some minor bugs.
DataNumen SQL Recovery 2.3 is released on May 12, 2014
- Support to recover MDF/NDF data from undamaged or damaged VMWare VMDK (Virtual Machine Disk) files (*.vmdk), Virtual PC VHD (Virtual Hard Disk) files (*.vhd), Acronis True Image files (*.tib), Norton Ghost files (*.gho, *.v2i), Windows NTBackup files (*.bkf), ISO image files (*.iso) and Nero image files (*.nrg).
- Fix some bugs.
DataNumen SQL Recovery 2.2 is released on March 18, 2014
- Improve the recovery accuracy.
- Fix some bugs.
DataNumen SQL Recovery 2.1 is released on January 9, 2014
- Support SQL Server 2014.
- Fix some bugs.
DataNumen SQL Recovery 2.0 is released on December 7, 2013
- Improve the recovery speed.
- Reduce the memory consumption during recovery process.
- Fix some bugs.
DataNumen SQL Recovery 1.1 is released on August 3, 2013
- Support to output file in MDF format.
- Improve the recovery speed.
- Reduce the memory consumption during recovery process.
DataNumen SQL Recovery 1.0 is released on May 11, 2013
- Support SQL Server 2005, 2008, 2008 R2, 2012.
- Support to recover the structure and data in the tables.
- Support to recover all data types, except for XML type.
- Support to recover sparse column.
- Support to recover deleted records.
- Support to recover multiple files, including MDF file and its associated NDF files.
- Support to repair MDF files on corrupted media, such as floppy disks, Zip disks, CDROMs, etc.
- Support to repair a batch of MDF files.
- Integrated with Windows shell, so you can repair a MDF file with the context (right click) menu of Windows Explorer easily.
- Support drag & drop operation.
- Support command line (DOS prompt) parameters.
Related Products
DataNumen Database Recovery
Database recovery suite, including recovery tools for corrupt Microsoft Access databases and DBF databases.
Details
DataNumen Access Repair
Repair and recover corrupt Microsoft Access databases (.mdb and .accdb files).
Details
DataNumen SQL Recovery