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 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

How can I manage MySQL in WebSitePanel?

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

How can I login to Webmail in Websitepanel?

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

How to setup Schedule Task (Cron Job) to exexute an URL in WebsitePanel?

This article will show you how to setup a schedule task or cron job in WebsitePanel Control Panel...

Powered by WHMCompleteSolution