Import Database into Plesk

Import Database into Plesk

How to import a MSSQL database - Windows Shared

This process cannot be done via the MSSQL client. Instead, it must be completed inside of the control panel using these steps:

  1. Create a blank MSSQL database.
  2. Restore the Blank Database With the Database Backup File.

Create a Blank MSSQL Database

To create a blank database on a Windows Shared Server:

  1. Log in to your control panel. Click Websites & Domains if it is not already selected, then click Databases.

  2. Click Add New Database.

  3. Enter a name for the database, and database user. Be sure to select Microsoft SQL Server as the Type. Click Generate to create a password for the database user. Finally, click OK.

Restore the Blank Database With the Database Backup File

To restore a blank database with a database backup file:

  1. Log into your control panel and click Websites & Domains if it is not already selected, then click on Backup Manager.

  2. Select Database Backup Repository.

  3. Click Upload Backup File

  4. Select the database you wish to import to, then click Browse to select the file you wish to import. Next, click OK to continue.

  5. Click Confirm the Restoration, then click OK to complete the process.

    • Related Articles

    • Resource Monitoring with Plesk

      Monitoring the resource usage on the server is vital to properly managing the system and your hosted accounts. To check the resource usage on the server you first need to log into the Plesk as the admin user. Once logged in, click Health and ...

    • How to import/export mysql via SSH commandline

      Managing Databases via Command Line (SSH) Using SSH can be a superior way to manage the files and databases on your account. Using a simple command you can import or export a MySQL database into an existing database on your account.   Please note ...

    • Restoring a MSSQL database from a .sql file using EMS Sql Manager Lite

      How do I restore an MSSQL database from a .sql file? If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql to download the freeware version and install to your local computer.   Start EMS Sql Manager. If ...

    • Windows Plesk DNS and Private Nameservers

      Plesk Manages DNS within the domain interface within Plesk.  When adding a domain, if you choose the option to allow Plesk to add the default records for you, it will create all required DNS entries.  Custom entries can also be created as required. ...

    • How do I backup a MySQL database?

      Backing up your MySQL database can be done couple different ways. Method #1 Using the phpMyAdmin web interface included in the Hsphere CP Method #2 Using command line utility "mysqldump" Using the phpMyAdmin Method: To access phpMyAdmin, you will ...