How to Restore SQL Server Databases in MSP Control

WSP Tutorials

Restoring SQL Server Databases

This article shows you how to Restore SQL Server Databases in the Hosting Control Panel.

1. To restore your SQL Server database, you will need a full backup in one of two formats: the standard SQL Server .bak file format or the Azure .bacpac format. A .bak file is a typical backup file provided by your hosting provider, while a .bacpac file is used with Azure. If you are creating the database using SQL Server Management Studio, make sure to create the backup in either the .bak or .bacpac format.

2. Log into your Hosting Control Panel.

3. Click SQL Server icon option

4. Click on the name of the SQL Server Database that you wish to restore from your backup

5. Click on Maintenance Tools

6. Under Maintenance Tools click on the Restore button

7. From Restore SQL Database screen you can select a Database Backup in either the standard SQL Server .bak or Azure .bacpac format from your local computer to upload by selecting Uploaded File or if you have already uploaded the Database Backup to your Hosting Space using FTP select the second option for Hosting Space File

8. Once you have selected the location of your SQL Server Database Backup click the Restore button to restore your SQL Server Database

Back To Hosting Control Panel Tutorials Menu

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.