The software makes it possible to recover your valuable information from SQL Server databases hit by minor or severe corruption. Below mentioned list describes prominent features of the software:
SQL recovery application is designed to combat data loss due to corruption in SQL Server databases. The tool works for all scenarios for database corruption arising due to application crash, OS malfunction, unexpected system shutdown, virus attacks, etc. It scans the entire database for mangled entries and corrects the bit pattern to eliminate corruption and bring the database to a consistent state.
The 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 due to logical fragmentation, database shrinkage, and bugs, it makes both the files victim and brings the database in an inaccessible state. The SQL recovery software carries out SQL repair for all objects of .mdf and .ndf files.
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, and more. In addition, the tool supports recovery of XML indexes and data types, column set property, sparse columns, and file stream data types.
The software enables you to perform selective recovery of database objects. The functionality allows you to select specific objects that have to be recovered from the list and save them at any location on the computer.
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 feature also enables you to verify if resultant contents match the original data that was available in the database prior to corruption.
SQL tables with PAGE and ROW compression are also in scope of SQL database recovery by the 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.
You does not need to search for items manually from the list displayed after scanning, as the 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'.
On completion of SQL recovery process, you are provided with an option to save recovered database at a desired location on the computer. Moreover, the queries of severely corrupt objects that cannot be recovered by the tool can be saved in a separate text file.
The SQL recovery application is capable of fixing a number of corruption errors, such as suspected database, Clustered Index Leaf Level Corruption, Consistency Corruption, and possible schema corruption etc.
The impressive ribbon in the upper part of the software makes it easier to find the various options and use them. The menu item can also be customized and individual options can be added or removed to make the recovery process even more quick and efficient.
The software has the ability to reconnect to the MS SQL server automatically, when there is a disruption during the repair process. This ensures that the repair process runs smoothly.
Stellar Phoenix SQL Recovery is compatible with the following:
File Size:6.10 MB
Yes, the 'Demo' version of Stellar Phoenix SQL Recovery runs a thorough scan against the selected SQL database and displays all recovered objects for preview in the main interface. You can preview any object to check the accuracy of scan results. For saving the recovered database, you need to register the product.
Stellar Phoenix SQL Recovery does not require an SQL Server installation for displaying the preview of repairable database objects. This implies that you can verify the recovery results after performing a database scan using the software without having MS SQL Server pre-installed on your system.
The software however, needs an installation of SQL Server for saving the recovered database objects. The tool works by creating a new SQL Server database, and then saving all the recovered objects to this new database.
You should make a copy of your database and run recovery on this copy instead of the original file in order to mitigate the risks of any accidental damage to the file. The software by itself is equipped to prevent any modifications to your database. However, if something goes awry (power spike, system glitch), you may run the risk of damaging the database structure or the contents of your database file.
No, the software simply repairs the corrupt file and restores data in a new file without tampering the original file.
Yes, Stellar Phoenix SQL Recovery also includes repairing and recovering database from suspect mode.
Check that the file belongs to any of SQL server 2000, 2005, 2008 version. If yes, it indicates the severe corruption in file, which is beyond recovery by any application. To get the file repaired, you need to send it to us so that our professionals can analyze and repair the file. You can reach us via email at email@example.com.
Yes, the application supports repairing and recovering all objects of both MDF and NDF files
Yes, the software is able to identify the version of SQL Server where the file was created.
Yes, the software allows you to perform selective database recovery.
Yes, the software recovers the database when DBCC CHECKDB command fails.
Yes, the software covers all common errors, such as possible schema corruption, suspected database, etc.
Stellar Phoenix & Stellar Data Recovery are Registered Trademarks of Stellar Information Technology Pvt. Ltd.
© Copyright 2014 Stellar Information Technology Pvt. Ltd. All Trademarks Acknowledged.