Darshan Hiranandani - How do I set up automatic backups for my Google Cloud SQL database?

[darshan2]

Hey team, I'm Darshan Hiranandani, looking to set up automatic backups for our Google Cloud SQL database. Does anyone have experience with this and can offer guidance on the best practices or steps to follow? Any help would be much appreciated, thanks!

[christianpaula]

Hi @darshan2,

Welcome to Google Cloud Community!

Create and manage on-demand and automatic backups:

Create an on-demand backup: To create an on demand back up:

1. In the Google Cloud console, go to the Cloud SQL Instances page.
2. To open the Overview page of an instance, click the instance name.
3. Select Backups from the SQL navigation menu.
4. Click Create backup.
5. On the Create backup page, add a description, if needed, and click Create.

Schedule automated backups:

1. In the Google Cloud console, go to the Cloud SQL Instances page.
2. To open the Overview page of an instance, click the instance name.
3. Select Backups from the SQL navigation menu.
4. Click Edit, next to Settings.
5. Choose a window of time for your data to be automatically backed up.
6. Click Save.

Note: If an on-demand backup is ongoing when an automatic backup is scheduled to begin, the automatic backup is rescheduled for a later time.

Documentation Reference:

• Create an on-demand backup
• Schedule automated backups
• Set a custom location for backups
• View a list of backups

I would highly suggest visiting these documentation for best practices when creating an automatic backup in Cloud SQL database.