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

How to login to Websitepanel control panel?

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

I am getting 500 Internal Server Error (Windows Server 2012/Websitepanel) in Browser

Here is the tips for finding the real error:Please add <httpErrors errorMode="Detailed"/>...

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.

Powered by WHMCompleteSolution