(SQL) Tip of the Day: Geo-Repl for Standard Databases in SQL Azure

Today’s (SQL) Tip…

Built on the same continuous copy mechanism as Active Geo-Replication, Standard Geo-Replication asynchronously replicates committed transactions from the primary database to one secondary database. The secondary, unlike Active Geo-Replication, is offline and does not accept client connections. It is visible on the list of secondaries and the continuous copy status can be monitored using the DMVs. The offline secondary can be switched to active if there is a datacenter issue resulting in unavailability of the primary database. In such an event, the failover property of the database is enabled. This allows you to terminate the relationship between the primary and the secondary, thus activating the offline database and making it an independent database ready to accept client connections.

You can read more about it here: https://msdn.microsoft.com/en-US/library/azure/dn758204.aspx