SQL Server Database Software - FAQ's
This section provides answers to FAQ’s about MS SQL server database recovery software and corrupt MDF database files restoration.
Q: What type of information can be extracted from corrupt MDF files by Geeksnerds SQL Database Recovery software?
A: The software tool has been designed with advance data recovery algorithms to fix corrupted MDF files. Following information can be extracted from corrupt MDF files using SQL Database Recovery Software.
- It can recover database schema
- It can show and recover all the objects of database such as tables, views, constraints, indexes, triggers, store procedures and rules.
- It can fix corrupt .MDF file
- It can recover from corrupt database including Primary Key, Foreign Key and Unique Key.
- It can perform recovery of Index(s) and Constraint(s) for a given database MDF file.
Q: Which SQL server versions are supported by the Geeksnerds SQL recovery software?
A: Geeksnerds SQL Recovery software can be used to recover from corrupted .MDF/. NDF database files created using the following Microsoft SQL Server Versions:
- SQL server 2000
- SQL server 2005
- SQL server 2008
- SQL server 2008 R2
- SQL server 2012
For saving 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 then the current or upper version of source database of MS SQL server must be installed. e.g. if the user has MDF database file of SQL server 2008 and want to save it in SQL Server 2005, then in this case user might have incomplete saving of data because of some data types that are supported in SQL server 2008 which are not supported in SQL server 2005.
Q: What are the functionalities that can be performed with the demo version of the software?
A: Geeksnerds SQL recovery software's demo version performs all the functionalities that are offered by the full version except the save functionality. For MS SQL Server MDF database files, user can repair, extract, fix the DB but it can’t be saved in demo version of the software.
Q: What are different types of MS SQL Server Database files? Can you please specify which files types are supported for software recovery using Geeksnerds MDF Recovery Tool?
A: There are three types of database files created by MS SQL Server.
MDF Database Files:
This is the primary database files in a SQL Server Database also called Master Database File. MDF files store all the information relating to the database header and system table. It is required to recover database, backup and log.
NDF Database Files:
This is the secondary database file in a SQL Server Database. If the MDF is corrupt, then NDF file can be helpful in recovery. For that you have to place it in the same directory as MDF database files before proceeding with recovery process.
LDF Database File:
This is the transaction log files. This file is not required for MDF database files recovery process and its presence doesn’t affect the recovery results.
Q: Is it possible to recover the stored procedures only?
A: Yes, it is possible by selecting and using “Recovered Checked” option. All user has to do is to mark those stored procedures and select the “Recovered Checked” option form toolbar or menu bar. Then follow the instruction on the software “SQL Saving Wizard” to save the information as script/database.
Q: Can I repair Selective tables using the software?
A: Geeksnerds SQL Recovery software can recover selective tables. Once the scanning of the MDF file is complete, user can verify all the records including data, tables, views, stored procedures, rules, defaults, user defined data types, triggers, indexes and constraints for lost, corrupt, damage or deleted entries. You can then extract only selective tables by check marking the tables required to be repaired and as an output you will get a new MDF file containing the selected tables. Likewise user can generate script as well for selected information.
Q: How to check the content of a MDF/NDF database file of MS SQL server database?
A: The software shows all the entries, record and information present in a database file. Just click on “Open MDF File” and select the SQL database file. Software will scan the files for contents and then will show all the information and entries present in the database files. The software can be used as reader of MDF database file to check the contents of the file. The “Search Table” option can be also used. User can click on the table and give the input and software will search the selected table for required information. This makes the process of verifying the content of different MDF database files simple and convenient.