How to recover a damaged MS SQL Server database?

Databases are the very basis of many corporate information systems. Practically any information can be stored in them, from real-time to accounting. Even temporary unavailability of this information can lead to serious losses. Let alone their permanent loss! Nevertheless, this situation is quite real. Physically, databases are just regular files that can be easily damaged due to a virus attack, software, file system or hard drive failures, careless operations, etc. In any of these cases, a database cannot be opened and therefore the entire information stored in it becomes unavailable.

SQL Server Recovery Toolbox (download) will help you cope with this problem and get back the data that seemed to be lost forever. It is used to extract and save information from damaged MS SQL Server databases (the following files are supported: Microsoft SQL Server 7.0, 2000, 2005, 2005 64-bit, 2008 and 2008 R2). Of course, SQL Server Recovery Toolbox cannot guarantee that the entire data will be recovered completely. You should understand that sometimes it can be so seriously damaged that it is just impossible to extract some part of information. The process of recovering and saving the information from a damaged MS SQL Server database in SQL Server Recovery Toolbox is carried out with the help of a step-by-step wizard. You have to perform only one action in each step, which is very comfortable and practical.

It is necessary to specify the damaged MS SQL Server database in the first step. The most comfortable way to do it is to use Windows Explorer opened with a click on the button. The *.mdf and *.ndf extensions (the standard extensions of MS SQL Server) are specified as the filter. All files that have been analyzed once are stored in a special quick access list. To select them after that, you just click the icon, move the mouse pointer to the necessary document and click the left mouse button.

Use the Next button to move to the next step. At this moment, the program will display a dialog box with a question whether it is necessary to analyze the source file. In case you answer yes, it extracts service data from the database and shows the information it can recover. The window is divided into two parts for your convenience. The left part shows all possible information categories: User Tables and System Tables, Views, Stored Procedures, Functions and User Defined Data Types. When you select any of them, the right part of the window will show the list of available objects and their contents. You should carefully look through it and make sure that SQL Server Recovery Toolbox will cope with the task and that it can actually recover the lost data.

The method of saving the information is selected in the next step. The thing is that this tool can either save the data extracted from the damaged file to the hard drive as a set of scripts in the SQL language or export it directly to the MS SQL Server database. The first method is good because it allows you to move the extracted information to any server. To do it, you just copy the package of scripts to the necessary computer and run it there. And the second case is more convenient when the computer the data is recovered on is connected to the necessary database. In this case, the information is exported in it without any additional actions.

Then you have to choose the information that should be recovered from the damaged file and save it. For you to be able to do it, SQL Server Recovery Toolbox again shows what it can extract. And you have to choose the necessary data by selecting/clearing the corresponding checkboxes. You can select the entire database, whole information categories or separate objects (tables, views, stored procedures, etc.) or clear these selections at once.

After you select what you need, you can start the process of scanning the source file and saving the information extracted from it. Click the Start Recovery button to do it. The direction of this process depends on two factors. First, the source file (its structure and size). And second, the performance of the computer where it is being carried out. It should be mentioned that databases are sometimes very large and the information recovery process may take several days. Right after the process is completed, SQL Server Recovery Toolbox will display the log. It contains data for all information recovery processes completed during the current session.

Thus, SQL Server Recovery Toolbox is a good tool for recovering data from damaged MS SQL Server databases. It is distinguished by two peculiarities. The first one is effectiveness. The tool in question can recover as much information as possible from a damaged file. The second peculiarity of SQL Server Recovery Toolbox is that it is extremely easy to use. Any user, even one who is just beginning to learn how to use the computer, can use this program to extract information from a damaged database and save it without taking any learning curve.

Screenshots Gallery

See also:

How to import saved scripts into MS SQL Server database? (

How to recover MS SQL Server database from several files? (