MS SQL Database Recovery software can recover database files created on Microsoft SQL Server Version 2000, 2005, 2008, 2008 R2 and SQL Server 2012. For saving the new information as scripts of MDF database, MS SQL server installation is not required however if user wants to save recovered/repaired corrupt database as new database file then current version of source database of MS SQL server must be installed.
SQL Recovery Software can recover information, objects and data from MDF or NDF files. Master Data Files (MDF) is primary file with all the information. NDF file is secondary file and supplement the main files. If you have both the MDF and NDF files, then place the NDF files in the same folder as MDF files and select MDF files for Recovery. The SQL Database Recovery software will detect the NDF files. NDF files help in improving and refining recovery result in a MS SQL database recovery situation. All the important information including data, tables, views, stored procedures, rules, defaults, user defined data types, triggers, indexes and constraints of corrupt MDF file can be saved using MDF and NDF files.
Geeksnerds SQL Recovery software recovers database in three steps:
- Select the MDF/NDF file for recover
- In the second step the file is scanned and the contents of the files are show to the user.
- The third and final step is to save the database information.
The 1st and 2nd Steps can be performed in demo version of the software however for third step registered version is required. In the third step the information can be saved as new MDF files or as script/query. The software also gives the user option to save complete database or to save selective data, tables, store procedures, rules, user data types, triggers, indexes and constraints.