If you have received the the Backup file in a compressed format, you will want to place this compressed file in a directory you have access to.
Please note that this example is showing 7ZIP compression. Other Compression software might have a different process.
Open the Compressed file
Highlight the backup file that is within the compressed file
Then depress the Extract icon
The following will display, you will want to populate the Copy To with the directory that you wish to restore the file to.
Depress Ok button
You can confirm that the Backup file (bak) has been placed in the specified directory.
Open your SQL Server Management
Select Server Name
Log In using SQL Server Authentication
Once logged into the Server you can then right-click on Database
Select Restore Database.
While in the General Page
select Device
Then depress the browse button
Within the Select Backup Devices screen depress the "Add" button
Within the Locate Backup File screen
Locate or paste the File path of where your Backup files is located
You might see it right away or you might have to change to "All files"
The Select the BAK file and make sure that it is displayed in the File Name field.
Depress OK
You will be returned to the Select backup devices screen
You will see your backup media populated
Depress the OK button
The General Page will look similar to this
Make sure to type in the desired Database name. In this example I selected "ManexTest"
Then select the Files Page from the left.
While in the File Page you will want to check Relocate all files to folder
Paste in the file path where you wish to keep the database
then also confirm within the Restore As field that the MDF and LDF file name matches what you are naming this database. (Sometimes it might retain the Original Database name in the restore as fields)
Then go into the Options Page
Check to see if Tail-Log Backup items are active.
If they are you will want to make sure to uncheck these
Depress the Ok Button
You should then see a progress bar in the upper right hand corner
Once finished you will see the following message.
Upon returning to the SQL Manager you should see your new database has been restored.
Article ID: 5555
ManEx, Inc. Content intended for information only. Do not redistribute without written consent.
