Taking database backups and restoring them via the Plesk panel ensures data integrity, enables disaster recovery, and allows for seamless migration or deployment of MS SQL databases across environments.
Follow the steps:
- Backup MS SQL Database:
- Log into Plesk.
- Go to Websites & Domains > Databases.
- Select the MS SQL database you want to back up.
- Click on Backup.
- Configure backup options.
- Click on “Ok” button.
- Download the backup file once the process is complete.
- Restore MS SQL Database:
- Log into Plesk.
- Go to Websites & Domains > Databases.
- Select the database where you want to restore the backup.
- Click on Import Dump.
- Select the backup file and click OK to restore.
Was not that simple? We hope you enjoyed our article. If you encounter any challenges, please do not hesitate to contact our support team.
Looking for another method to take backups? Check out our guide on How to Take MySQL Backups with phpMyAdmin