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

 
Step 1 Start DataNumen SQL Recovery.

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.
Step 2
Select the corrupt or damaged 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.