Recovery Toolbox for SQL Server (formerly SQL Server Recovery Toolbox)
Normally, SQL servers are secure solutions for data storage. While this is true in most cases, sometimes errors do appear, which can cause significant losses, more-so if occurring in a business environment. Recovery Toolbox for SQL Server can help users solve such issues, as it provides solutions for commonly encountered SQL errors.
Fix MDF or NDF errors
Issues addressed include page level and table corruption errors, database consistency problems, or incorrect metadata fields. Also, one can target database header issues, damaged partition tables and unreadable databases in the suspended state; the tool can process items in MDF and NDF formats.
The program's setup is very intuitive and easy to grasp, as a built-in wizard guides users through all the steps necessary to recover data. These things being said, the application cannot repair all issues related to faulty databases, case in which users can opt for the 'send a file to developers' help-function.
Selectively repair damaged items and export data
The tool can process most databases created with SQL version 7.0 or later. Once a valid document has been selected, the utility displays the readable internal structure of the source file, effectively allowing users to preview recovery results.
One of the notable features of this program is the ability to fix and export information from MDFs selectively. This is performed with simple checks on corresponding boxes and, once satisfied with the results, the recovered data can be sent to a new Microsoft SQL Server.
The general impression left by this program is that of a user-friendly solution for most common MDF errors
To conclude, Recovery Toolbox for SQL Server is a good tool for users with damaged SQL servers. The tool provides fixes for most common errors, including those pertaining to incorrect headers and table corruption issues.