Step 7 - Backup Databases - Microsoft SQL Server (ODBC)
Choose your database management system:
Microsoft SQL Server (VSS) | Microsoft SQL Server (ODBC) | Oracle | MariaDB | MySQL |
Step1
1. After login to Cloudbacko Go, click on the Backup Sets tile.
Step2
2. Click on the “+” to add new backup set
Step3
3. Enter the backup name, i.e. "MS SQL 2017". Select backup set type MS SQL Server Backup.
Step4
4. Select the backup mode, i.e. ODBC. Then enter the MS SQL Server login details. Click Next to continue.
Step5
5. Select the databases you wish to backup. Click Next to continue.
Step6
6. Create an automatic backup schedule, i.e. Full database backup every Saturday at 23:00, daily transaction log backups at 20:00. Click Next to continue.
Step7
7. Select a storage destination, i.e. CloudBacko Drive. Click Next to continue.
Step8
8. Use the default Encryption setting and click Next to continue.
Step9
9. Click Confirm to continue.
Step10
10. Enter Windows administrator login details. Click Next to continue.
Step11
11. Backup set is created.
Click on Backup now to start a backup job or wait for the automated backup to start.