Click "Recovery" tab in the dialog, you can start recovering a corrupted MDF database(.mdf) file, or recover MDF/NDF file data from undamaged or damaged virtual machine disk files, backup files or disk image files:
1.Input or select the corrupted MDF database(.mdf) file to be recovered. You may also click the search button to search and select the MDF database(.mdf) file to be recovered in the local computer.
2.If there are one or more associated NDF files, then you can add them in the list.
3.If you know the SQL Server version of the corrupt MDF file, then you can specify it in format combo box. If you don't know, then just specify "Auto Determined".
4.If your SQL Server MDF/NDF file is stored on the following file:
•VMWare VMDK(Virtual Machine Disk) file(*.vmdk). For example, you store your SQL Server MDF/NDF file on a virtual disk in VMWare.
•Virtual PC VHD(Virtual Hard Disk) file(*.vhd). For example, you store your SQL Server MDF/NDF file on a virtual disk in Virtual PC. Or you make a backup of your SQL Server MDF/NDF file via Windows Backup and Restore function.
•Acronis True Image file(*.tib)
•Norton Ghost file(*.gho, *.v2i)
•Windows NTBackup file(*.bkf)
•ISO image file(*.iso)
•Nero image file(*.nrg)
and you cannot access the data in the MDF/NDF file for some reasons, for example:
•You delete your SQL Server MDF/NDF file from the virtual disk in VMWare or Virtual PC.
•You format the virtual disk in VMWare or Virtual PC by mistake.
•The virtual disk in VMWare or Virtual PC cannot be mounted or launched properly.
•The virtual disk in VMWare or Virtual PC is corrupt or damaged.
•The backup file on the backup media is corrupt or damaged and you cannot restore your MDF/NDF file from it.
•The disk image file is corrupt or damaged and you cannot retrieve your MDF/NDF file from it.
•And many more ...
then you can still recover the data in the MDF/NDF file by scanning and recovering the corresponding virtual machine disk file, backup file or disk image file. Just select the file as the source file to be recovered.
If you only have one virtual machine disk file, backup file or disk image file containing the MDF/NDF file data, then you should specify it in "Select MDF/source file to be recovered". If you have several virtual machine disk files, backup files or disk image files containing the MDF/NDF file data for a single database, then you can specify one of them in "Select MDF/source file to be recovered", while adding the remaining to "Select NDF/source files associated with the MDF/source file".
You can also use "Format" to specify the format of the data in the MDF/NDF file to be recovered.
5.Specify the output file name. The output file will be a plain text file containing all the SQL statements that can be used to reconstruct the data. The extension of the output file is .sql. You can open it in SQL Server Management Studio and execute it.
6.Click "Start Recovery" button to start the recovery process. You will see the change in progress bar. If you want to abort the recovery process, click the "Stop Recovery" button.
7.After the file is recovered successfully, you will get a messagebox tell you how many user tables are recovered.
8.You can click the "Save Log" button to save the recovery log into a file. You can include additional information in the log file by selecting the "Include System Information" option in the save file dialog. These information can help our technical supports to diagnose your system and solve your problems more efficiently.
•If you are using a demo version of DSR, then after the reparation, it will popup a messagebox where you can click "Show Data" button to view all the recoverable data in the database. Please order the full version to get the recovered data.