Portal Home > Knowledgebase > Database Management > [PLESK] How to Back and Restore Microsoft SQL Server database

[PLESK] How to Back and Restore Microsoft SQL Server database

With Parallels Plesk Panel, you can back up and subsequently restore the databases, database user accounts and data used by domains hosted on your server. You can:

  • Back up your domain databases with all data and user accounts
  • Restore databases from backup files
  • Download, upload and remove database backup files
  • Recover users who became orphaned after the restoration.

[PLESK 9.5] To back up a database:

  1. Go to Domains > domain name > Backup Manager -> Database Backup Repository.
  2. Select a check box corresponding to the database you want to back up and click Back Up.
  3. Specify the name of the backup file and click OK.
  4. If you want to download the resulting backup file, click the file name on the next page after the backup process was finished. Specify the location where you want to save the file and click Save.
  5. Click OK.

[PLESK 9.5] To back up all databases on a domain:

  1. Go to Domains > domain name > Backup Manager > Database Backup Repository, make sure that All domain repositories is selected in the Database field, and click Back Up.
  2. Specify the name of the backup file and click OK.
  3. If you want to download the resulting backup file, click the file name on the next page after the backup process was finished. Specify the location where you want to save the file and click Save.
  4. Click OK.
 
[PLESK 9.5] Restoring database backup:
 
If the database already exists and you only need to restore its content:
 
  1. Go to Domains > domain name > Backup Manager > Database Backup Repository, select the required backup file from the list and click Restore Selected.
  2. If you do not have the backup file on your server, you can upload the backup file to the server repository from your local machine. For more information, refer to the section Uploading Database Backup Files to Server (below).
  3. Confirm the restoration by selecting the corresponding check box and click OK.
 
 
Uploading Database Backup Files To Server:
 
  1. To upload a backup file to backup repository:
  2. Go to Domains > domain name > Backup Manager > Database Backup Repository and click Upload Backup File.
  3. Select the database in which repository you want to upload the backup file to in the Database name menu.
  4. Click Browse... and select the required backup file.
  5. Leave the Restore database backup immediately upon uploading check box selected if you want the database contents to be restored immediately after the backup file is uploaded.
  6. Click OK.
The database backup file will be uploaded to the backup repository of the specified database.
 
If the database does not exist and you need to recreate it from scratch:
 
  1. Go to Domains > domain name > Databases and click Add New Database.
  2. Specify the database name, type and server for the database you are restoring.Note. You can specify a new database name, but you must choose the correct database type: for example, if you are trying to restore a MySQL database, choose MySQL database type.
  3. Select the Restore database from backup file check box.
  4. Specify the location of the database backup file. You can upload a backup file from your local machine or specify a file located on the server.
  5. Provide the default username and password for the restored database.
  6. Click OK.
 
If you are restoring MS SQL database, there is a possibility that some database users will be orphaned. In order to provide the ability to access and use the database for these users, you need to repair them.


Also Read