How to Back Up and Restore MS SQL Server Database with WebSitePanel or Plesk

How to Back Up and Restore MS SQL Server Database with WebSitePanel or Plesk

It is of great necessity to back up and restore the whole SQL database in case for any data loss caused by a system failure. Besides that, a SQL server usually maintains a wide set of system-level databases, and you will have to make a regular copy of your database after any important updates.

At this place, we will discover the detailed steps to make a backup copy of your MS SQL database and demonstrate how to restore it. Note that, we would like to take the example of the mostly-used control panels in the world of Windows web hosting, namely WebSitePanel and Plesk control panel.

Back Up and Restore a MS SQL Database via WebSitePanel

In most cases, to back up and restore a MS SQL database requires a Microsoft software application named as SQL “Server Management Studio.” But things can become much easier for webmasters who already have Windows hosting accounts with WebSitePanel control panel included. In the following, we would like to explain how to back up and restore your MS SQL database with the use of WebSitePanel step by step.

Step 1 – Login to Your WebSitePanel
As usual, you should firstly log into your WebSitePanel account with unique username and password. Once you have entered the admin page, you will notice that there are many editing options, including “Domains”, “Web”, “FTP Accounts”, “File Manager” and much more. Here, move your computer mouse to the “Database” icon and select the very database that you are using now.

Login to Your WebSitePanle

Step 2 – Choose Your Database to Backup
If done, you will be switched to a new page where you are able to create a new database according to your requirement. At this place, you should search and select out the database you want to back up. Note that, you can choose to search it by “Username”, “Full Name” or “E-Mail.” Once done, make a click on its name and then you will be able to enter another settings page.

Chose Your Database to Backup

Step 3 – Click on “Backup” Option
On this “SQL Database Properties” page, you can have an overall look at your “Database Name” and “Internal Server” as well as “External Server.” Other database related information, such as “Users” and “Database Files”, is also shown.

Click on Backup Option

As above, you shall open the “Maintenance Tools” tab where you are allowed to “Backup” and “Restore” your database. Now, click on the “Backup” button to proceed with your backup. By the way, you can also “Truncate Files” on a SQL server in the below “Housekeeping Tools.”

Step 4 – Make Necessary Settings
As you can see, this new “Backup SQL Database” page allows you to make some necessary settings before your backup. In the below image, you will need to verify your “Backup File Name” firstly, and then decide whether to have a “ZIP Backup” file.

Make Necessary Settings

And in the “Backup Destination” section, you are allowed to download the previously-made backup file through HTTP or to copy it to a unique folder. Don’t forget to click on the “Backup” button at last. It takes a while to accomplish this backup process.

Step 5 – Download Your Backup File
When the backup is completed, you will have to download this “.zip” or “.bak” backup file to your own computer or a local server via FTP program. After downloaded it successfully, you need to delete the backup file from your server. For your data security and integrity, it is recommendable to back up your MS SQL server database periodically.

Restore a MS SQL Database in WebSitePanel
If needed, you can choose to restore your database by simply clicking the above-mentioned “Restore” button under “Maintenance Mode”. And then, you will need to click the “Hosting Space File” option so that you can restore a database based on the saved backup file. Alternatively, you are able to select the “Uploaded File” option to achieve your goal. Before you start out to “Restore”, make sure that everything goes right as expected.

Restore Your SQL Database

Back Up and Restore a MS SQL Database via Plesk

Honestly speaking, to back up and restore a MS SQL database with the use of the “SQL Server Management Studio” application is a kind of hassle especially for those who have a limited technical background. However, the use of Parallels Plesk control panel makes it a breeze to back up and restore your MS SQL database without requiring any database management knowledge. In the following parts, we would like to explain how simple it is to perform this “huge” project in detail.

Step 1 – Make a Backup of Your Database
At the very beginning, you are expected to have a backup file of your database for later use. To do that, you will have to login to your Plesk account so as to enter its user interface. As you can see, there are a couple of tabs on the top menu of this page, including “Home”, “Users”, “Mail”, “Applications” and much more.

Make a Backup of Your Database

Here, expand the “Websites & Domains” tab and you will have a list of editing options, including “Applications”, “FTP Access” and “Web Statistics”, etc. For now, you only need to go to “Backup Manager” > “Database Backup Repository” as below.

Database Backup Repository

And next, you shall choose the particular database to backup, and in the meantime, click the “Back Up” button. Pay attention that, you are required to define this ready-to-generate backup file before clicking “OK” button. Last but not the least, you still need to download this “.bak” or “.zip” file to your local computer.

Step 2 – Create a New Database
Next, you should go back to the “Websites & Domains” tab again so as to find out the following “Database” icon. Now, make a click on its link as below.

Database Icon

On this newly-opened page, click the “Add New Database” link and you will get an application form. Be aware that you would fill in your preferred “Database Name” and create personal “Username” and “Password.” Remember to specify your “Database Type.”

Create a New Database

Step 3 – Restore from Backup File
Having created a new database successfully, you will have to go back the homepage and go to the “Websites & Domains” tab once more. In the same way, select out the “Backup Manager” option and make a hit on an icon saying “Database Backup Repository.” Once done, you shall choose to “Upload Backup File” by clicking the correspondent option as follows.

Restore from Backup File

And now, you are sure to get a wizard that allows you to restore the previously-downloaded “.bak” file. If you happen to save your backup file as “.zip”, you will need to extract it before uploading it to your server.

Important to Note: As a matter of fact, the above-mentioned wizard will upload your “.bak” file to “Database Repository” firstly, and it will require you to restore this file to certain databases created before. Keep in mind that you’d better not include any strongly-typed database name and username in your backup file.

Based on what we have discussed above, it takes little effort to back up and restore a MS SQL database with the use of WebSitePanel and Plesk control panels. If you want to seek out professional help to prevent getting stuck by any potential issues, we have the following trustworthy recommendations.