Help Needed: Recovering Lost Data from Cloud SQL Beyond Backup Period

[thaiduong]

Hello everyone, we're facing a critical situation with data loss in our production Cloud SQL database. Several tables have been completely wiped, disrupting our users' operations. The data loss occurred about two weeks ago, but our automated backup retention only covers the last 7 days.

We've explored several recovery options:
1. Automated backups aren't helpful since they only go back 7 days
2. Our most recent manual backup is from a year ago, which is too outdated to be useful
3. We have CSV files, but they're even older - from 5 years ago

What we're wondering is: Does Google retain any data beyond the standard backup period that could be accessed through Enhanced Support (https://cloud.google.com/support)? Is it worth reaching out to Google's customer support to see if they can help recover this data?

(We want to make sure they are able to help because upgrading to Enhanced Support costs us extra money)

Any advice or experience with similar situations would be greatly appreciated. Time is crucial as this is affecting our production environment.

P.S: Our configs:

 

[mcbsalceda]

Hi @thaiduong,

Welcome to Google Cloud Community!

According to Google Cloud’s documentation, there might still be a chance to recover some of the data through point-in-time recovery (PITR), if it was enabled prior to the data loss. PITR allows you to restore the database to a specific point in time, which could help recover data that was lost or corrupted. However, if PITR wasn’t enabled or the backup period is too short, the options are limited. Google Cloud’s automated backups typically retain data for up to 365 days, depending on the instance settings, so it might be worth checking if they can extend that period. If you're unable to restore the data through backups, it might be a good idea to reach out to Google Cloud Support. They can provide guidance and might have additional options available through their Enhanced Support plans, especially for more complex recovery scenarios.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.