We are excited to announce General Availability of license-free standby replica for Azure SQL Database letting you to save on licensing costs by designating your secondary disaster recovery database as standby replica. Typically license costs constitute to be about 40% and so with license-free standby replica the secondary will be about 40% less expensive.
To protect database powering the application from region failures and achieving higher business continuity it is crucial to enable disaster recovery for database. In some industries it is mandatory and part of compliance requirement to have disaster recovery in place and frequently conduct drills. One of the biggest hindrances in enabling disaster recovery has been cost as secondary database is mainly used in the event of a disaster.
When a secondary database replica is used only for disaster recovery, and doesn't have any workloads running on it, or applications connecting to it, you can save on licensing costs by designating the database as a standby replica. Microsoft provides you with the number of vCores licensed to the primary database at no extra charge under the failover rights benefit in the product licensing terms for standby replica. You're still billed for the compute and storage that the secondary database uses.
The standby database replica must only be used for disaster recovery. The following lists the only activities that are permitted on the standby database:
- Perform maintenance operations, such as checkDB
- Connect monitoring applications
- Run disaster recovery drills
You can designate one secondary single database deployment model as license-free standby replica in General Purpose & Business Critical service tier and provisioned compute tier. It is possible to configure license-free standby replica using portal, powershell or CLI.
Additional capabilities added for general availability release are:
- Perform in place update of geo replica to standby replica using portal and REST API.
- Assign standby replica while creating failover group using portal and REST API.
- Estimate cost for standby replica by using Azure pricing calculator and selecting Standby replica in Disaster Recovery dropdown.
For comprehensive details on license-free standby replica including limitations and frequently asked questions, please refer to documentation.
