Backing Up and Restoring Databases (Windows)

If you are using a Windows-based customer account, then you can back up and subsequently restore databases, database user accounts, and data used by your websites.

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.

Important: Plesk does not back up stored procedures, views, and triggers. The backup utility ignores them and, therefore, they cannot be restored.

To back up databases:

1. Go to the Websites & Domains tab > Backup Manager > More Actions > Database Backup Repository.
2. Using the Database menu, select the databases you want to back up.
3. Click Back Up.
4. Specify the name of the backup file and click OK.
5. 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.
6. Click OK.

To restore a database:

1. Go to Websites & Domains tab > Backup Manager > More Actions > Database Backup Repository, select the checkbox corresponding to the backup file you want to restore and click Restore.

   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.

2. Confirm the restoration by selecting the corresponding checkbox and click OK.

To upload a backup file to a backup repository:

1. Go to Control Panel > Websites & Domains tab > Backup Manager > More Actions > Database Backup Repository, and click Upload Backup File.
2. In the Database name menu, select the database in whose repository you want to upload the backup file.
3. Click Browse and select the required backup file.
4. 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.
5. Click OK.

The database backup file will be uploaded to the backup repository of the specified database.