|
Import MSSQL database to a Plesk server |
|
|
|
|
Question: How do I transfer my local MS SQL file to server?
Solution:
1) First ensure you are on one of our Plesk servers. Otherwise you should use Enterprise Manager or SQL Management Studio to remotely connect and import your data.
2) Login to your Plesk Control Panel
3) Go to Database option and create new database and user
4) Now create database dump (backup) of your local database. And create .bak file
5) Upload .bak file to /httpdocs folder of your website. (FTP upload)
6) Contact support and request that we restore your database with following details
a. Your domain name
b. .bak file name and path to access that (e.g /httpdocs/mybackupfile.bak)
c. MS SQL DB name
7) We will confirm the restore of your database when it is complete.
|