Home > SI5 Documentation > User Guide > Installation/Admin > Tips and Tricks > Restoring MDF from BAK file

Restoring MDF from BAK file

Table of contents
No headers

When you need to restore a BAK file to a SQL Server database where the BAK file was not originally backed up from or when you need the MDF out of a BAK file you can follow these steps. You will need to use SQL Server Management Studio Express to achieve this.

***I have found that this works better if you login using SQL Authentication. 

Expand Databases and then right click –> Restore Database

1.jpg

Select the database that you need to REPLACE in the To Database: section.

2.jpg

 

The source selection will be From device and you will select your BAK file and then click on the Restore checkbox.

3.jpg

Click the Options tab in the upper left and choose Overwrite the existing database. Now you can press the OK button in the bottom right.

4.jpg

If everything is mapped correctly it should go through 100% and tell you that the restore has completed successfully.

5.jpg

 

Last modified
13:02, 26 Nov 2013

Tags

This page has no custom tags.

Classifications

This page has no classifications.