How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop)

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.

STEP-01
Connect to the server, provide the required credentials.

How to Restore a Backup of Database in SSMS



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 Database via Remote Desktop (SQl Server Management Studio)


STEP-03
Right-Click on the Database name "test" and Click "Tasks". Click "Restore", then click "Database"

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-04
Choose "Device", then click "..."

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-05
Select the Backup Devices.

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-06
Find the Backup database from the folder.

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-07
Click on OK.
How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-08
Restore the Database

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-09
Choose "Options" and "Restore Options".
Tick the "Overwrite the existing database 9WITH REPLACE)"

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-10
Restored successfully!

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-11
Delete the Database existing user.

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)

STEP-12
Delete the object

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-13
How to connect to User mapping

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-14

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)


STEP-15

How to Restore a Backup of Database via Remote Desktop (SQl Server Management Studio)

DONE!


  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How can I manage MySQL in WebSitePanel?

Please login phpMyAdmin through http://www.yourdomain.com:9900 to manage MySQL databases.

How To Create FTP Account In WebSitePanel Control Panel?

1. Login to WebsitePanel 2. Click 'FTP Accounts' Icon3. Click 'Create FTP Accounts' button4....

How can I manage MSSQL in WebSitePanel?

Please download MSSQL 2012 Server Management Studio from...

How to Restore or take a Backup of MSSQL Database in WebsitePanel?

How to Restore or take Backup MSSQL Database in WebsitePanel? How to create database on your...

How can I login to PhpMyAdmin on WebSitePanel?

Please go through http://www.yourdomain.com:9900

Powered by WHMCompleteSolution