Backing Up a Google Cloud Database SQL Server

You can perform a full backup operation of Google Cloud Database SQL Server.

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

2. On the Instances tab, click the instance.

3. On the Subclient tab, click the subclient that you want to back up.

4. Click Backup.

5. On the Select backup level dialog box, under Backup level, select Full, Transaction log or Differential.

6. Click OK.

Backup level details

• Full – No restrictions.

• Transaction log – Requires Automatic Full backups and Point-in-Time Recovery (PITR) to be enabled on the SQL Server. When PITR is enabled, GCP automatically backs up transaction logs in an internal bucket, which can then be exported via GCP REST API calls.

• Differential – Requires Automatic Full backups to be disabled on the SQL Server. This is necessary because any automatic full backup will invalidate differential backups taken before the automatic full.