DataNumen logo Header Header
  Site Search:
 
  Home » Products » DataNumen SQL Recovery » How to recover
 
         
 
Arrow DATANUMEN SQL RECOVERY
   
  News
  Recovery
  Download
  Order
  FAQ
  View Screenshot
  Awards
   
Arrow RELATED PRODUCTS
Arrow DataNumen Access Repair
Arrow DataNumen DBF Repair
Arrow DataNumen Database Recovery
Arrow DataNumen Oracle Recovery
 
Using DataNumen SQL Recovery to Recover Damaged MDF Files
   

When your mdf files are damaged or corrupt 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.

 
Note: You can try free method to recover your database first, before using DataNumen SQL Recovery.
Step 1 Start DataNumen SQL Recovery.
Note: Before recovering any damaged or corrupt mdf files with DataNumen SQL Recovery, please close any other applications that may modify the mdf files.
Step 2
Select the damaged or corrupt mdf file to be repaired.
Select MDB File to be Repaired

You can input the mdf filename directly or click the Browse for Source MDB File button to browse and select the file. You may also click the Find button to find the mdf file to be repaired on the local computer.

Step 3

If there are one or multiple NDF files associated with the damaged MDF file, then you can add them as well:


Select NDF File to be Repaired
Step 4

If you know the format of the source damaged MDF file, then you can specify it:

Select NDF File to be Repaired

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.

Step 5

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:

Select Fixed File Name

You can input the fixed file name directly or click the Browse for Destination MDB File 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.

 

Step 6

You can also let DataNumen SQL Recovery output the fixed file as a .SQL file, as follows:

Select Fixed File Name

You can input the fixed file name directly or click the Browse for Destination MDB File 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.

Step 7

Click the "Start Repair" button, and DataNumen SQL Recovery will start scanning and repairing the source mdf file. Progress bar Process 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:

Message Box

Step 8

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.

Note:

The demo version will display the following message box to show the success of the recovery:

Demo Version Message Box

where you can click the "Show Recovery Report" button to see a detailed report of all the recoverable data in the mdf file, including all the tables and records, like this:

Recovery Report

According to the report, you can know whether DataNumen SQL Recovery can recover your mdf file. However, the demo version will not save the fixed mdf file. Please order the full version to get it.