QuestionQ95

VerifiedMigrate data solutions

You perform daily exports of native BAK files from Cloud SOL for SOL Server to Cloud Storage buckets by using the gcloud sql export bak command at 6:00 AM. You want to automate this routine with managed Google Cloud components so that you can focus on other critical tasks of keeping your database healthy and performant. What should you do?

Explanation

Cloud SQL does not provide built-in scheduling for BAK exports. An automated managed workflow can use Cloud Scheduler to run daily, Pub/Sub to deliver the event, and a Cloud Run function to invoke the Cloud SQL BAK export operation. Retained and automated backups do not create the required native BAK exports in Cloud Storage.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!