Advertisements
Home > DBA Stuff, Reviews > SQL Recovery utility by SysTools | easily Recover your corrupt Database in few clicks

SQL Recovery utility by SysTools | easily Recover your corrupt Database in few clicks


In business organizations, most of the application’s back end operations rely on database systems like Microsoft SQL Server. SQL Server helps to manage the database which ultimately houses all the storage information. SQL Server is responsible for all the back end operations for hundreds of applications and so we can easily retrieve information through a series of SQL queries. Nevertheless, if a SQL database gets corrupted; will the processes of the entire organization come to stand still? Well if the data maintained in the database are not recovered, then there are chances of the disruption of the processes concerned with the entire organization. However, if you are lucky enough to get through a software like SQL Recovery then things are really going to shape in a good way and you will be able to recover all your data items from any corrupted database.

–> Here is a closer look on the features of “SQL Recovery” utility to realize what it offers to users:

Disclaimer: This is not a paid review, and reflects my own experience while working with the product.
 

The SQL Recovery utility from [SysTools Group] proves to be a transformational approach for recovering the corrupted database of SQL Server. Being completely a Windows based tool, it has been developed with the basic motive of recovering damaged data from the MDF and NDF files of SQL server by saving the extracted data on Windows Operating system. Later, you can export the extracted data directly into SQL server. It is just simple to rely on this masterpiece utility that gets your work done in some seconds. You get to recover the tables, rows, columns while not worrying about any data loss. To take a lead on the recovery process, let us first get started with some notable features of the application.

–> Basic Potentialities of the Recovery Tool:
1. Provides a convenient option to save the scan of the corrupted database as .str file format that can be handy at times when there is any kind of interruption in the transaction process of SQL Server.
2. The automatic detection of SQL Server version helps to run the recovery process without any kind of confusion.
3. Often users or system administrators employ DBCC CHECKDB command to resolve the corruption related issues. However, there are occasions when the DBCC CHECKDB fails to perform and in such situations user can definitely trust on this recovery tool.
4. Supports the recovery of XML data if the user has created XML type variables or columns on SQL Server.

–> Functionality in Details:
Some of the functionalities of the program are completely beneficial to users. Have a look on these functional aspects, to know more about this software.

1. Scanning options: For recovering the MDF and NDF files, users are provided with two feasible options (as shown in image below):
– Quick scan: select this option, for faster scanning of MDF files.
– Advance scan: If your files are highly corrupted then choose this option.

scan-mode
 
2. Preview the Database Items: Once the MDF and the NDF database of SQL server are recovered, you will get a preview of all the contents of the database. Users will get to see all the repaired data items like tables, views, triggers, etc.

preview-sql-data
 
3. Flexible Export Options: For exporting the recovered database, users can select any one of the option
(1) SQL Server Database and
(2) SQL Server Compatible Scripts

– Export Directly To Live SQL Server: If you are interested to place your files directly into the Live SQL Server then provide the details of database such as Server name, username, password, etc. and export the data conveniently to the database of server without any data loss.

– Export as SQL Server Compatible Scripts: If you select this option for exporting the recovered database to SQL Server, then a .sql file is created that can be easily saved on your system. This file will help you to restore data into the server anytime.

export-option
 
4. Export MDF with/without schema: While exporting the recovered MDF database, the software facilitates users to export the database with only the schema of tables, stored procedures, etc. However, you also have the option to export MDF data with both schema and data.

schema-data
 
5. Export Deleted Records: Another attributed feature of the tool is that while exporting the database to the server, you have the option to export the deleted rows, tables, or column again to the database. A prompt appears on the screen, if you are interested for exporting the deleted data to the database, select yes otherwise click on no.

export-deleted-records
 
–> The SQL Recovery utility can be downloaded from the SysTools website (both Trial & Licensed version): http://www.systoolsgroup.com/sql-recovery.html

The demo version of the SQL Recovery utility is available for users to test its functionality in details. However, with the free trial version you will be able to recover all the items of the corrupted SQL database and onlypreview them. To export or save the recovered database, you need to go for the licensed version of the application.

The setup file is of 6.10 MB and it gets easily installed on the system. The latest version 6.1 has come up with features that are more promising and provides capabilities of improved speed and accuracy while working on the application. SQL Recovery tool is completely compatible with Windows 8.1 and all other previous versions.

–> Working Areas:
– You cannot add multiple MDF files with the software. However, there is an option to add multiple files and folders when you select a NDF file
– The software does not provide a process summary report of what all items are exported to the SQL Server. Users do not get an idea about the details of items exported to SQL Server database

–> Wrapping it up:
Offering an efficient recovery process, strong performance, and incredible operability the SQL Recovery Tool comes out successfully to delivers on all fronts. Further, the array of options and the user specific customizations provided by the software rightfully claims it as the best one among its competitors.

Advertisements
  1. Alex
    May 25, 2015 at 12:35 pm

    Manoj, thanks for this informative review. My favorite is Stellar Phoenix SQL database repair. I have been using this from last 3 years through some version upgrades. It has repaired several corrupt SQL database files for my clients. But if I got error message then I simply start with DBCC CHECKDB with suitable repair levels.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: