Microsoft SQL Server Management Studio is available for free from Microsoft and can be downloaded through this link: https://msdn.microsoft.com/en-us/library/mt238290.aspx
Once downloaded, Install and open MSSQL Management Studio from the Start menu.
Connect to the server, provide the required credentials.
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database in SSMS](https://bluechipspace.com/other-images/kb/SQL-STEP-01.png)
STEP-02
Choose your database name from the list you have created from the Websitepanel control panel. Here it is showing as "test"
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-02.png)
STEP-03
Right-Click on the Database name "test" and Click "Tasks". Click "Restore", then click "Database"
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-03.png)
STEP-04
Choose "Device", then click "..."
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-04.png)
STEP-05
Select the Backup Devices.
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-05.png)
STEP-06
Find the Backup database from the folder.
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-06.png)
STEP-07
Click on OK.
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-07.png)
STEP-08
Restore the Database
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-08.png)
STEP-09
Choose "Options" and "Restore Options".
Tick the "Overwrite the existing database 9WITH REPLACE)"
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-09.png)
STEP-10
Restored successfully!
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-10.png)
STEP-11
Delete the Database existing user.
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-11.png)
STEP-12
Delete the object
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-12.png)
STEP-13
How to connect to User mapping
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-13.png)
STEP-14
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-14.png)
STEP-15
![How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop) How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)](https://bluechipspace.com/other-images/kb/SQL-STEP-15.png)
DONE!