Configure Google Cloud Database SQL Server Running on Cloud

The databases server configuration guides you through creating a backup plan and adding a Google Cloud Database SQL Server.

Navigate to Service Catalog

From the navigation pane, go to Service catalog.
On the Service Catalog page, in the Databases tile, click Configure.
On the Configure Database Server page, select Database running in the cloud (PaaS).
Select Google Cloud Platform, and then click Next.
On Configure Google Cloud Database page, select SQL Server, and then click Next.

The Configure Google Cloud database - SQL Server page appears.

Configure Service Account

Create service account

Use a Google Cloud service account credential to authenticate with Google Cloud resources for backup, restore, and management operations.

To create a new service account with required permissions, do the following:

Beside the Credential field, click + button .
On the Add credential dialog box, do the following:
1. From the Authentication Type list, select a service account.
2. From the Credential vault list, select a credential vault.
3. In the Credential name box, enter the name of the credential.
4. Create a service account. After the account is created, the Service account ID field is populated with an ID number.
5. In the Private key file, upload the JSON key file that is associated with the Google Cloud service account.
6. In the Description box, enter the credential description.
7. From the Key Rotation Reminder Interval list, Specifies how often the system reminds you to rotate the service account key.
8. Click Save.
Click Next.

Use existing service account

When you use an existing service account, ensure that the service account has the required Google Cloud permissions.

When you select Use existing service account, do the following:

Select an existing credential from the Credential dropdown, then click Edit icon to configure the service account by assigning a custom role with the required permissions.
Click Next.

Access Node

You can select your own access node for the backups.

On the Configure access nodes page, you can select the following two options:
- Use hosted infrastructure
- Use your access nodes for backups
- If you select Use hosted infrastructure, from the Region list, selected a region of the hosted infrastructure.
- If you select Use your access nodes for backups, from the Access nodes list, select an existing access node or add a new access node.
- Click Next.

Plan

Google Cloud Database SQL Server requires a continuous schedule policy for transaction log backups, therefore, new plans are automatically created with a continuous schedule.

On the Select plan page, select an existing backup plan or create a new backup plan. To add a new backup plan, do the following:
1. Click the add button .
  
  The Create backup plan dialog box appears.
2. In the Plan name box, enter a descriptive name for the backup plan.
3. Select an existing Storage or add a new storage.
4. Select Configure backups and perform schedule and retention settings.
  1. Define the frequency and retention period of your backup.
  2. Under Add extended retention, define the following:
    - From the Backups to retain list, select the kind of backup you want to retain.
    - From the Retention period list, select the days for which you want to retain the backup.
  3. Select Add second copy to create a second copy for redundancy across different storage or regions.
  4. Select Add third copy to create the third copy for maximum redundancy.
5. Click Save.
Click Next.

Cloud Account

The cloud account is used to access the databases for discovery, backups, and other operations.

On the Cloud account page, select an existing cloud account or create a new cloud account.

Note

The cloud account for a cloud database instance cannot be modified after the instance is created. Deleting a cloud account or hypervisor permanently deconfigures all associated cloud database instances. Deleting a server from (Manage > Servers) permanently removes all associated cloud database instances. Before deleting a cloud account, hypervisor, or server, ensure that you understand the impact on dependent resources and retain any required backup data.
Steps to add new cloud account
1. Beside the Cloud account field, click +.
  
  The Add cloud account dialog box appears.
2. In the Name box, type the name for the account.
3. In the Credential box, the credential selected during service account configuration is auto populated.
Click Next.

Instance Details

Specify the settings for the cloud database instance.

On the Cloud database instance details page, from the Instance name list, select the name of an instance.
In the Staging bucket path box, enter a temporary path for storing data during backup or restore operations.

Note

If you move the Automatically select staging path toggle key to right, the Staging bucket path box is not visible.
You can either select an existing SQL server authentication or add a new one. To add a new SQL server authentication, do the following:
Steps to add a SQL server authentication
1. Click +.
  
  The Add credential dialog box appears.
2. From the Credential vault list, select a credential vault.
3. In the Credential name box, enter the name of the credential.
4. In the Username box, enter the user name.
5. In the Password box, enter the password.
6. In the Description, enter the description of the description.
7. From the Key Rotation Reminder Interval list, Specifies how often the system reminds you to rotate the service account key.
8. Click Save.
Click Next.

Backup Content

On the Backup content page, all the database in the Google Cloud Database SQL Server instance will be backed up.

Summary

Review the summary, and then click Finish.