SQL recovery software makes it possible to recover your SQL Server database hit by minor or severe corruption. Some prominent features of the software are:
Repairs SQL Server Database
SQL database recovery application is designed to combat data loss due to corruption in SQL Server databases. The tool works for all scenarios of database corruption arising due to hardware problem, bugs in SQL server itself, application crash, OS malfunction, unexpected system shutdown, virus attacks, etc. SQL recovery tool scans the entire database for mangled entries and corrects the bit pattern to eliminate corruption and bring the database to a consistent state. Read More
Restores Objects of MDF and NDF Files
The SQL recovery software is apt for repairing corruption that includes both MDF and NDF files of SQL database. MDF (.mdf) is the primary file containing database header and system table information, whereas NDF (.ndf) file is secondary database file. When corruption occurs within the SQL server database, it makes both the files victim and brings the database in an inconsistent state. The SQL recovery software carries out SQL repair for all objects of .mdf and .ndf files.
Performs Deleted Record recovery
This utility also facilitates its users to recover deleted records of corrupt database while performing the repair function. You can restore all your deleted records without any modifications in the original hierarchy and save them in a newly created table just under the original file to determine the difference between recovered deleted records and repaired corrupt file and save them as required.
Multiple Saving options
Furthermore, this tool is programmed to offer you multiple saving options that automatically increase the usability of the software. You are allowed to save the repaired SQL server database file in CSV, HTML, and XLS format at desired location. In this way, this proficient SQL repair software can be very useful for you as these different formats don't need installed SQL server on your system to open the file.
Repairs all Database Components
The diverse nature of the software makes it possible to recover all components of database, such as Indexes, Views, Tables, Triggers, Stored Procedures, Rules, User Defined Functions, Keys and more. In addition, the tool supports recovery of XML indexes and data types, column set property, sparse columns, and file stream data types.
Preview of Database Objects
The application scans the entire corrupt database and displays the list of all recoverable items in a tree-like structure and the tables are listed in sorted manner. You can select any table to view its contents. Moreover, the preview feature also enables you to verify if resultant contents match the original data that was available in the database prior to corruption.
Allows Selective Recovery
Stellar Phoenix SQL Database Repair software enables you to perform selective recovery of database objects. The functionality allows you to select specific database objects that have to be recovered from the list and save them at default or any specified location on the computer.
Recovers ROW and PAGE compressed Data
SQL tables with PAGE and ROW compression are also in scope of this SQL database recovery software. Moreover, the tool also supports SCSU (Standard Compression Scheme for Unicode) for SQL Server 2008 R2 and recovers all the data in its original format.
Allows Searching the Items
You do not need to search for items manually from the list displayed after scanning, as the SQL Repair software provides a 'Find Items' option that facilitates searching for intended items on the basis of specific criteria, such as 'Match whole word' or 'Match case'.
Allows Saving the Recovered Data
On completion of SQL database recovery process, you are provided with an option to save recovered database at default or any desired location. Moreover, the queries of severely corrupt objects that cannot be recovered by the tool can be saved in a separate text file.
Fixes SQL Database Corruption Errors
This SQL database repair software is capable in fixing numbers of SQL server database corruption errors such as 5171, 8942, 3414, not a primary database file, header file corruption, database in suspect mode, clustered or non-clustered index corruption, consistency error, schema corruption and many more.
The impressive ribbon in the upper part of the software makes it easier to find the various options and use them. Menu items can also be customized and individual options can be added or removed to make the recovery process even more quick and efficient.
Reconnects Automatically when Disrupted
The software has the ability to reconnect MS SQL server automatically, when there is a disruption during the repair process. This ensures that the repair process runs smoothly.
Support and Compatibility
Stellar Phoenix SQL Database Repair software is compatible with Windows 10, 8, 7, Server 2008, Vista, Server 2003, XP and supports MS SQL server: 2016, 2014, 2012, 2008 R2, 2008, 2008*64, 2008 Express, 2005, 2005*64, Express, 2000, 2000*64, 7.0 and mixed formats.