Backups play a critical role in securing your data against possible loss. Here, we will guide you on how to create a backup of your MSSQL database using Plesk.
Important Note: This guide is written with the assumption that you're using Plesk for your hosting. If you are using cPanel hosting, we recommend this guide instead.
Method 1: Backup via Plesk Panel
Log into your Plesk Panel. If you need help with this, refer to this guide.
Go to the "Databases" section. Here, you will find a list of your existing databases.
Select your MSSQL database. Click on its name to open its settings.
Backup your MSSQL database. Select the "Export Dump" option and choose the directory where you want to store the backup file. Finally, click "OK" to start the backup process.
Remember, it's critical not to store your backups in your hosting space. Understand why that's important here.
Method 2: Backup via .bak File
This method requires you to have a .bak file, which is a SQL Server backup file.
Log into your Plesk Panel.
Go to the "Databases" section and select your MSSQL database.
Import your .bak file. Choose the "Import Dump" option and navigate to your .bak file. Select the file and click "OK" to start the import process.
Method 3: Backup via ldf/mdf Files
These are your SQL Server's data files (mdf) and log files (ldf).
Access your server's file system. You can usually do this via FTP or a file manager tool.
Locate your ldf/mdf files. These are usually stored in the MSSQL directory.
Copy your ldf/mdf files. You can now store them in a secure location.
Local Backups: Always remember to have local backups of your data. Understand the importance of local backups here.
Lastly, it's good to know that HosterPK also takes courtesy backups using jetbackups. Learn more about it here.
If you also need to create a backup of your MySQL database, we have a step-by-step guide here.
Please note that creating backups should be a regular practice, not just a one-time activity. Ensuring regular backups of your databases keeps your website safe and allows for easier recovery in case of any unexpected data loss.