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

Managing SQL Server Management Studio 2012 Databases with WebsitePanel

How to create database on your WebsitePanel control panel and manage with Microsoft SQL Server...

How can I manage MSSQL in WebSitePanel?

Please download MSSQL 2012 Server Management Studio from...

How can I login to Webmail in Websitepanel?

Please go through this link http://www.yourdomainname.xyx:9998

How can I login to PhpMyAdmin on WebSitePanel?

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

How to login phpMyAdmin to manage MySQL on Websitepanel?

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

Powered by WHMCompleteSolution