Knowledgebase
How do I perform MS SQL database back up through Control Panel (Plesk 9)?
Posted by Sean Syed on 21 February 2013 07:07 PM
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.

To back up a database:

  1. Go to Files > domain name > Backup Manager -> Database Backup Repository
  2. Select a database you want to back up from "Database" drop down list and click Back Up. 
  3. Specify the name of the backup file (database_backup.bak) 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.

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.
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).