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

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

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 to login to Websitepanel control panel?

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

How To Create FTP Account In WebSitePanel Control Panel?

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

Powered by WHMCompleteSolution