Backing Up Databases in Plesk
1. Login to your Plesk panel
2. Click Database
3. To BACKUP and existing Database, click on Export Dump.
4. Save the dump in any preferred location with your account, Click OK to complete.
Note that if "Automatically download dump after creation" is checked, the dump is automatically downloaded unto your local drive.
A box with progress bar shows up by the side of the window, you are also automatically notified about the status of the backup.
Restoring Databases in Plesk
1. Click on import database
(Read how to How to export sql dump from Mssql Management Studio )
2. Choose Upload (if file is on your local drive) or Click Import and select appropriate sql dump file (.zip format)
3. Click OK to proceed