If you use SQL Server in your organization for smooth working of operations then you have chosen a good application. In SQL Server - creating a database is essential for normal working in the enterprise. In case your SQL Server Database has got corrupted due to any unseen reason, then you need to recover SQL Server database. Using SysTools SQL Recovery tool, you can perform SQL Server 2008 database recovery with great ease. For SQL Server 2000 database repair process also, you can use our tool.

Steps to Fix SQL Server Database using Our Tool: For successful completion of recovery process to restore SQL Server database, you need to follow the steps given below:

1. Run SysTools SQL Recovery Tool onto Your System: Go to Start >> Programs >> SysTools SQL Recovery >> SysTools SQL Recovery. Initial software screen that flashes on your system appears as shown in the following screenshot:

2. Load the database by clicking on Load option.

3. Select Corrupted SQL MDF File: Now, click the ‘Browse’ button on the initial software screen to choose corrupted MDF file. Given below screen is displayed:

4. Scan the Database.

5. Save the scan in a .str file so that you do not have to scan it again.

6. Select the location where you want to save the scanned file.

7. View data by clicking on “+” and expanding the tree.

8. Click on Export to open the export option dialog box.

There are two ways through which you can export the database to your Microsoft SQL Server. The first one is directly to the server and the second one is through scripts.

9. Exporting directly to SQL server
If you are using Windows Server Authentication in SQL Server, then you will have to provide only Server Name and Database Name. However, if you are using SQL Server authentication then you will have to provide Username and Password too.

10. Selecting the database to be exported with only schema or with schema and data.
If you select With only Schema then this option will enable you to create schema for the selected tables/views/procedures. If you select the option With Schema and Data then it will let you export schema as well as data for the database.

11. Click on Export/Save to export the records.

12. Click “yes” if you want to export the deleted records as well.

13. You will receive a prompt if the connection is successful.

14. You can view the exported records count.

15. You can also save the report in a .csv file.

16. View restored database in Microsoft SQL Server.

17. You can also recover and restore the database using scripts.

18. Click “YES” if you want to export deleted records as well.

19. Select the location where you want to save the scripts.

20. You can restore the database using the scripts by following the steps provided in the text file at at the given location.

21. You can view the recovered database.