To restore a SQL DB from a backup, follow the steps below:


1. You should have received the backup file in a compressed format, and you will want to place this compressed file in a directory you have access to.

Note: the below example is showing 7ZIP compression. Other Compression software may require a different process. 





2. Open the Compressed file.


Highlight the backup file that is within the compressed file, then depress the "Extract" icon.





3. Populate the field name, "Copy To," with the directory you want to restore the file to.


Depress "Ok." 

 



4.  Confirm that the Backup file (.bak) has been placed in the specified directory. See below image:





5.Open your SQL Server Management and Select the server name.


Log in using SQL Server Authentication.



6. Once logged into the Server, right-click on the folder named, "Database."


Select "Restore Database."



 

  

7. While in the General Page, select "Device" and depress the browse button

  



8. Within the Select Backup Devices screen, depress the "Add" button.

 



9. Within the Locate Backup File screen, locate or paste the file path of where your Backup files are located.


You might see it right away or you might have to change to "All files"


Next, select the .bak file and make sure that it is displayed in the File Name field.


Depress "OK"




10. You will be returned to the Select backup devices screen 

The backup media should be populated.

Depress the "OK" button.

 



11.The General Page will look similar to this.


Make sure to type in the desired name for the database. In this example, the name is "ManexTest"


Then select the "Files Page" from the left.




12.While in the File Page, check the box to called, "Relocate all files to folder."

Paste in the file path where you want to keep the database.

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)

Next, go into the Options Page.




13. Check to see if Tail-Log Backup items are active.

If they are active, make sure to uncheck these.

Depress the "Ok" Button




14.  You should then see a progress bar in the upper right-hand corner like the below image:




15.  Once finished, you should see the following message:




16. Upon returning to the SQL Manager, you should see your new database has been restored.