Restoring an SQL .bak file into a new blank database

The following process can be used to move an existing database to a different drive or to check your backup integrity without restoring over your working database:

1. Open the SQL enterprise manager.
2. Expand the tree until you see your server.
3. Highlight your server.
4. Click on the wand in the upper toolbar.
5. Double-click on ‘Database’
6. Click 'Create Database Wizard'
7. Click 'OK'
8. Click 'Next'
9. Enter the name you want to use for the new database.
10. Enter the desired location for the new database and transaction log.
11. Click 'Next'
12. Click 'Next' again.
13. Click 'Next' on the following screen with the default settings.
14. Click 'Next' again.
15. Click 'Next' on the following screen with the default settings.
16. Click 'Finish'.
17. You should see a "Database created successfully" message. Click 'OK'.
18. When prompted to create a maintenance plan, select "No".

A new empty database has been created. Now we'll restore the .bak file into this database.

1. On the left side of the screen, expand the database folder and select the new database you just created.
2. Right-click on the new database.
3. Select 'All tasks', 'Restore database'.
4. In the Restore option select 'From Device.'
5. Click 'Select Devices.'
6. Click the 'Add' button.
7. Click the three-dotted button to the right of the file name.
8. Browse to the .bak file you wish to restore.
9. Click 'OK.'
10. Click 'OK' again. You should be at the 'General' tab.
11. Click on the 'Options' tab.
12. Check the 'Force Restore Over Existing Database' checkbox.
13. Under the 'Move to physical file name' you will see a path.
14. Double click on that path so that it is highlighted and editable.
15. Change the path to the desired location, but leave the .MDF extension on the end of the new database name.
16. Do the same on the second line with the .LDF file.
17. Click 'OK' to begin the process.

PLEASE NOTE: It may take a few minutes before the process begins, so please be patient!

If you have any questions, contact our technical support department: support@mainsequence.net or (440) 946-5214

This document is provided for information only. The information contained in this document is the position of Main Sequence Technologies as of the date of publication. This information is not a promise or guarantee nor is the accuracy of any information generated after this item is published guaranteed.

This document is provided AS IS without warranty of any kind, express or implied, including but not limited to merchant ability, fitness for a particular purpose, and freedom from infringement.