{"id":2912,"date":"2017-06-23T12:39:55","date_gmt":"2017-06-23T12:39:55","guid":{"rendered":"http:\/\/www.fastwebhost.in\/blog\/?p=2912"},"modified":"2021-06-28T07:37:00","modified_gmt":"2021-06-28T07:37:00","slug":"upload-ms-sql-database-to-plesk-hosting","status":"publish","type":"post","link":"https:\/\/www.fastwebhost.in\/blog\/upload-ms-sql-database-to-plesk-hosting\/","title":{"rendered":"How to Upload MS SQL Database to Plesk Hosting Panel?"},"content":{"rendered":"

Earlier versions of Plesk were suppose to have database management tools to dump databases, but Plesk 12.5 allows you to back up (by exporting a database dump as an SQL file) and restore them (by importing a database dump as an SQL file) without leaving the control panel. The only thing you need to have a MS SQL Database with you.<\/p>\n

In this article we will learn how to upload the MS SQL\ufeff\ufeff\ufeff\ufeff Database<\/a> through Plesk panel.<\/p>\n

Before we start <\/h2>\n

The first step is to create 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.<\/p>\n

Once it is done, you can follow the below steps to create a New MS SQL Database on Database server and then restore it.<\/p>\n

Step 1 : Login to PleskPanel<\/h2>\n

Login to your Plesk account. On the homepage, click on the \u201cDatabases\u201d icon on the right hand side from the list.<\/p>\n

\"\"<\/span><\/p>\n

Step 2 : Adding MS SQL Database<\/h2>\n

Then click on the \u201cAdd a Database\u201d option on the page to get a form. Fill the “Database Name” you require and also create a “Database Username” and “Password”. Make sure you select MS SQL in Database Type.<\/p>\n

NOTE<\/strong>: You need to change the Server name, Database Name, Database Username and Database Password in your web application connection string as per the database you created on the server.<\/p>\n

\"Adding_Dataabase_to_PleskPanel\"<\/span><\/p>\n

Step 3 : Dumping your Database<\/h2>\n

Once database is created, you can check database list from your Database section on the screen, please find \u201cImport Dump\u201d option and click.<\/p>\n

\"Listing<\/span><\/p>\n

Step 4 : Importing Database Dump<\/h2>\n

Now, select your .bak backup file on your local machine. Make a note that it will accept only .bak file, so if you have the backup in .zip format then you need to extract it and then restore.<\/p>\n

\"Importing<\/span><\/p>\n

Step 5 : Final Check<\/h2>\n

After uploading file it will show one notification on your right side with file import status.<\/p>\n

You need to make sure that your .bak database file is a valid backup file and does not have any strongly typed database names or database usernames of your local database server.<\/p>\n

Note<\/strong>: To avoid potential data loss, never attempt to restore a database without taking a backup of your existing database with a unique filename.<\/p>\n

In this way you can upload your local MS SQL Database to your Plesk panel.<\/p>\n

Conclusion<\/h2>\n

Hope you like this article, where you can upload your local MS SQL Database to your PleskPanel. Also, we will be posting article soon on how to restore\/backup of your MS SQL database from Microsoft SQL Management Studio. Keep checking this space for more useful articles.<\/p>\n

The Best Windows Web Hosting Services in India<\/h2>\n

We at FastWebHost India provides amazing windows shared web hosting<\/a> service. It’s a real value for money web hosting service you ever find. We support 24\/7 no matter what. Give us a try and see yourself. <\/p>\n","protected":false},"excerpt":{"rendered":"

Earlier versions of Plesk were suppose to have database management tools to dump databases, but Plesk 12.5 allows you to back up (by exporting a database dump as an SQL file) and restore them (by importing a database dump as an SQL file) without leaving the control panel. The only thing you need to have […]<\/p>\n","protected":false},"author":10,"featured_media":3087,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[78],"tags":[141,134],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/2912"}],"collection":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/comments?post=2912"}],"version-history":[{"count":3,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/2912\/revisions"}],"predecessor-version":[{"id":5390,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/2912\/revisions\/5390"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/media\/3087"}],"wp:attachment":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/media?parent=2912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/categories?post=2912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/tags?post=2912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}