CODEWITHSUNDEEP
google-cloud-platformgoogle-cloud-sqlgcloud
Gcloud Help
Gcloud Help

Reputation: 31

Any chance of restoring a deleted gcloud sql instance?

Im obviously an idiot and I didn't sufficiently save data, but is there any chance of restoring a deleted gcloud sql instance that has been deleted, not just a db from backups because the whole instance has been deleted?

Upvotes: 3

Views: 2517

Answers (2)

juan-vg
juan-vg

Reputation: 109

It's actually possible to recover them if you are quick enough. They should still be there, even when Google says they're deleted.

If you know the name of the deleted DB run the following command to check if they are still there

gcloud sql backups list --instance=deleted-db-name --project your-project-name

If you can see any results, you are lucky. Restore them ASAP!

gcloud sql backups restore <backup-ID> --restore-instance=new-db-from-scratch-name --project your-project

And that's it!

Further info: https://geko.cloud/gcp-cloud-sql-how-to-recover-an-accidentally-deleted-database/

Upvotes: 7

DazWilkin
DazWilkin

Reputation: 40136

To my knowledge, there is no undelete for Cloud SQL instances.

If you pay for Cloud Support, before you do anything else, you may wish to contact support to see whether someone on that team is able to salvage the instance for you.

Upvotes: 4

Related Questions