When you are hosting a dynamic web application, you may need to use an MS SQL Server database with it. In order to achieve this, you will need to restore your local MS SQL Server Database to the Web Hosting Database Server.
Whether you are hosting for the first time or migrating from another server, Windows Web Hosting with Parallels Plesk Hosting Control Panel makes the task a lot easy. This article will guide you on how you can restore an MS SQL Server Database using Parallels Plesk Hosting Control Panel.
First step will be to prepare a .bak backup file of your local database on your local computer or download the .bak backup file from another hosting server if you are migrating your account from one server to another. Once that is done, please go through below steps to create a New MS SQL Database on Database Server and then restore it.
i. Login to your Plesk account. On the homepage, click on the “Databases” icon from the list.
ii. Then click on the “Add New Database” option on the page to get a form. Fill in the Database Name you desire and also create a Database Username and Password. Make sure you select MS SQL in Database Type.
NOTE: You will need to change the Data source/Serve name, Database Name, Database Username and Database Password in your web application’s Connection String as per database created on server.
iii. Once database is created, go to Homepage again by clicking on “Websites & Domains” main menu. Now to restore your database, click on the “Backup Manager” icon on Homepage.
iv. In Backup Manager, click on “Database Backup Repository” icon from the top horizontal list. From the page that opens, click on the “Upload Backup File” option. This will open a wizard which will allow you to restore your .bak backup file. Please note that it will only accept .bak file, so if you have the backup in .zip format then please extract it first then restore.
The above wizard will first upload the .bak file to database repository and then prompt you to restore it to a specific database already created on server. You need to make sure that your database .bak backup file is a valid backup file and does not have any strongly typed database names or database usernames of your local database server.
If the above method does not work for you, you can always use the conventional method of executing a published SQL Script via MS SQL Server Management Studio from local computer or MyLittleAdmin available in Plesk panel’s Databases section.
4992 total views, 3 views today