Hosting Tutorial & Guide

How to Backup and Restore MS SQL Database with Plesk Control Panel

updated on Sep 14, 2014
How to Backup and Restore MS SQL Database with Plesk Control Panel To make sure the data and files in the Microsoft operating system not be erased or collapsed by accident, you'd better backup and restore the SQL database in advance. Besides, it is not difficult for you to complete the whole process by making use of Plesk which is admitted as an easy-to-use and popular control panel with a lot of useful management tools in store for users.

Furthermore, we sum up the required steps for backing up and restoring MS SQL database based on our longstanding hosting experience on Windows hosting and the exertive surveys on backing up and restoring SQL database. Read the following parts and know more relevant details.

Make a Back Up of MS SQL Database

At the first place, although different versions of Plesk request different steps for backing up the database, the general steps for making a backup of MS SQL database are similar no matter you are using the Plesk 10 or 11. Thus, we would like give an elaborate explanation on the overall steps for backing up the database by taking Plesk 10 version for example. Details are showed as follows.

First of all, you are requested to log into the panel of Parallels Plesk by entering your own username and password in the corresponding checkbox. Having logged into the Plesk panel, you are able to see the Domains option in the column of Hosting Services which is displayed on the left side of the well-organized user interface. Then, make a click on the button of Domains and then click the link of Control Panel, which lies next to the domain name.

How to Backup and Restore MS SQL Database - Make a Back Up of MS SQL Database

After that, you are required to click on the tab of Websites & Domains, which is usually listed between the tab of Mail and Applications. Then, you can find the icon of Databases on the bottom of the page and you should make a click on Databases. Next, you need to select out the database needed to be backed up and remember to click the correspondent check box on the left side of the database name, such as johndoe.

How to Backup and Restore MS SQL Database - Make a Back Up of MS SQL Database

Having finished the mentioned steps, you need to click on the button of Webadmin in the column of Tools so as to link to phpMyAdmin. If everything goes right, a new tab will be opened and you should click the tab of Import. Then, click the button of Browse to put the selected-out backup file into the local computer. Don't forget to click the check box of SQL and click Go to save all changes and finish the whole backup for SQL database.

How to Backup and Restore MS SQL Database - Make a Back Up of MS SQL Database

Restoring MS SQL Database

Likewise, as the steps of restoring the MS SQL database using different versions of Plesk are similar, we would like to take the steps needed for restoring MS SQL database by using Plesk 9.5 for example. In a word, there is no need to worry even you are not familiar with Plesk, as the whole restoring process is rather simple without requesting related knowledge. Details are also presented as follows.

To restore the SQL database in Microsoft operating system, you need to firstly log into the admin panel of Plesk by entering your username and password. Don't forget to make a click on the button of Log in. When you have successfully logged into the user interface of Plesk, you should click the icon of Domains and in the meantime click the button of Domain Name. After that, make a click on the option of Backup Manager and then click the button of Database Backup Repository.

How to Backup and Restore MS SQL Database - Restoring MS SQL Database

What's more, you need to select out the back up files which are needed to be backed up from a list of once uploaded files on the local computer. Note that even you haven't uploaded the backup file onto the server, you are also capable of directly uploading the files into the server repository. Last but not the least, you are required to click the button of Restore to save all of the changes in the database and finish the whole process of restoring the SQL database in Microsoft system.