How to take backup & restore MS SQL database in PLESK ?

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.

  • 27 Users Found This Useful
Was this answer helpful?

Related Articles

I got 500 Error when viewing my Site ?

This normally happens because you turn on the Friendly Error on your IE. By default, IE always...

Plesk Windows Scheduler to call an ASP or ASP.NET

1. Click on 'Scheduled Tasks' in Plesk 2. 'Add New Task' 3. Enter a Description and Email if...

Steps to create MSSQL database and rates of extra MSSQL database

We provide MSSQL database in our Business Windows and upper windows hosting plans.You can create...

How do I send email from ASP using SMTP Authentication.

Please note that our mail server is configured with Authentication. Below is the code snippet...