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

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.

3. Select the 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.

4. Enter the backup set name, i.e. MS SQL Server (daily). Next select the backup mode, i.e. VSS. 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.

3. Select the Backup Set Type “MS SQL Server Backup”.

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.

6. Select a storage destination, i.e. CloudBacko Drive. Click “OK” to continue.

Step7
7. Select a storage destination, i.e. CloudBacko Drive. Click Next to continue.

7. Select a storage destination, i.e. CloudBacko Drive. Click “OK” to continue.

Step8
8. Use the default Encryption setting and click Next to continue.

7. Select a storage destination, i.e. CloudBacko Drive. Click “OK” to continue.

Step9
9. Click Confirm to continue.

8. Click “Next” to continue.

Step10
10. Enter Windows administrator login details. Click Next to continue.

9. Use default encryption settings. Click

Step11
11. Backup set is created.

Click on  Backup now to start a backup job or wait for the automated backup to start.

9. Use default encryption settings. Click