Recovering corrupted SQL Server Database using RecoveryFix for SQL Server

SQL Server stores the most important information inside an organization in its databases. These databases are stored in the form of MDF and LDF files on the disk drives. MDF files are the primary database files, whereas LDF files are the database transaction files. If any issue occurs to the MDF files then valuable information stored in it will be at stake. The situation can worsen if there is no backup at all or an updated backup has not been taken. In the absence of a native database recovery tool, it becomes mandatory to use a third party trusted tool for repairing the corrupted database. One such tool is RecoveryFix for SQL Server Database, which is like a boon if you’re facing any such issue. Here, we will discuss how to use this RecoveryFix tool for recovering a corrupted MDF file.

1. You will receive the following welcome screen on starting the software.

2.To change the Temporary file path, you can click the Browse button. This will display the following dialog box.

3. Select the folder and click OK button to change the temporary file path.

4. Select the version of MDF database to be repaired using Select MDF database version drop-down list. It contains the following values:

5. Click the Browse  button to select the corrupted MDF file to be repaired. This will display the following dialog box.

Ideally the MDF files are stored in this path- Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. You can also conduct a Windows Search to locate the MDF files.

6. Browse to the path where the file is stored, select the target MDF file, and click  Open button to open the file. This will take you back to the following screen.

7. Click the Next button at the bottom or Next  on the toolbar for starting the recovery process. Clicking it will display the following screen.

8.After completing the recovery process, this software will display the following screen.

The left tree panel displays the list of recovered items such as tables, user data types, views, stored procedures, rules, triggers, etc. You can expand the tree structure to select any individual item like a table, the content of which will be displayed in the right panel.

9. By default, no item is selected to be recovered. You can click the parent node of the database name to select all items for recovery. Alternatively, for selective recovery, you can select the items to be recovered in the left tree panel.

10. Click the Next button at the bottom or Next   on the toolbar for starting the recovery process. Clicking it will display the following screen.

11. RecoveryFix for SQL Server allows you to save the recovered file directly into the SQL Server in a newly created (already existing) database or saving the SQL Script on a disk. You can use the drop-down list titled Select saving using Drop-down list to select any of the following options.

i) Save into live SQL instance: It will restore the recovered database into a newly   

    created database on the connected SQL Server.
ii) Create SQL script on disk: It will save SQL script batch file on the disk to execute  the creation of a new database on the connected SQL Server.

12.Follow below steps for saving the recovered MDF file as a database on server.
i) Select the first option – “Save into live SQL instance”.
ii) Populate the SQL Server name and name of a newly created (already existing) database.
iii) Select the authentication mode and provide the login credentials for “Sever Authentication” mode if you’ve selected it.

13.Follow below steps for saving a SQL script that can be executed later on.
    i) Select “Create SQL script on disk”.

ii) Click the Browse  button to select the folder where you want to save the script file. This will show the following dialog box.

iii) Select the folder and click OK button.

14. Click  Save button for saving either the database on a server or script file on the disk. This will display the following screen.

15. You can click  Stop button to cancel this saving process; however, it will not save the script file on the disk.

16. Following dialog box will appear after completing the process to save the database on server.

17. Click on “Save” button to save the log as a TXT file or click OK button to proceed. It will take you to the following screen.

18.Click Home  button to go to the home page of the software. Click Back button to go back or click Finish button to close the application.

Conclusion

If you’re facing any kind of error while accessing the database or using it, then it might be corrupted. In case of no backup or an outdated backup, it’s recommended to use RecoveryFix for SQL Server as it will recover the corrupted database and let you save in an already existing database at your Server.

To read more about Recoveryfix for SQL Database, please visit http://www.recoveryfix.com/sqldatabaserecovery.html