Through Parallels Plesk Panel, you can back up and restore the databases
To back up MS SQL database:
- Go to Domains > domain name > Backup Manager -> Database Backup Repository
- Select a check box corresponding to the database you want to back up and click Back Up.
- Specify the name of the backup file and click OK.
To restore MS SQL database
- Go to Domains > domain name > Backup Manager > Database Backup Repository, select the required backup file from the list and click Restore Selected.
-If you do not have the backup file on your server, you can upload the backup file to the server repository from your local PC.
- Confirm the restoration by selecting the corresponding check box and click OK.
