QuestionQ36

VerifiedDeploy scalable and highly available databases in Google Cloud

You deployed a Cloud SQL for SQL Server instance and also created a cross-region read replica for disaster recovery (DR). Your company requires maintaining and monitoring a recovery point objective (RPO) of less than 5 minutes. You need to confirm that the cross-region read replica meets the permitted RPO. What should you do?

Explanation

Cloud SQL for SQL Server read replicas use SQL Server Always On Availability Groups with asynchronous replication. The SQL Server Always On Availability Group dashboard provides the replica replication status and failover-related data-loss information needed to assess whether the replica’s recovery point falls within the required five-minute RPO. Google Cloud’s cross-region replica DR guidance specifically identifies this dashboard in SQL Server Management Studio for checking replica replication status.

Learn more

Community Discussion

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