Having a backup is a must for every website. Backing up your database will helps you recover the website if recent changes that you’ve made cause an issue.
Hence, here is the way to backup your MSSQL Database for the Plesk Onyx Control Panel:
1. Login to Plesk Control Panel
2. Click Backup Manager
3. Click Back Up
4. Tick User files and databases
5. Select Full *for first time backup
6. Click OK