Overview

This support article describes how to create a new MSSQL database in Plesk and then import a MSSQL backup. This is typically done when migrating a website or when moving from a local development environment to a live server.

Instructions

  1. Login into Plesk via the Conetix Control Panel.
  2. Next click on Databases in the lefthand Nav:
    Plesk Obsidian – Create and import a MSSQL Database
  3. Next, Click Add Database:
    Plesk Obsidian – Create and import a MSSQL Database
  4. Enter the relevant details, Database Name, MSSQL Database type, Database User, Password, Confirm password then Ok.
    Plesk Obsidian – Create and import a MSSQL Database
  5. Click on Import Dump for the newly created Database to restore MSSQL backup:
    Plesk Obsidian – Create and import a MSSQL Database
  6. Select your MSSQL backup file either by browsing your local computer or under your hosting folder (if you have already transferred it via FTP):
    Plesk Obsidian – Create and import a MSSQL Database
    Import database backup task will start and display progress.
    Plesk Obsidian – Create and import a MSSQL Database
    Import completed
    Plesk Obsidian – Create and import a MSSQL Database
  7. You have now successfully created and imported a MSSQL database.
    Plesk Obsidian – Create and import a MSSQL Database

Was this article helpful?

Related Articles