locked
SQL database replication cost RRS feed

  • Question

  • I have S1 Standard tier SQL server databses as a service model. It has the default Geo-replication function, and cost of that is 30$/month.
    Still i not configured the geo replication.
    If I configure Geo-Replication for that S1 Standard tier SQL database then shall I need to pay any additional cost apart from 30$?????

    Friday, May 27, 2016 12:20 PM

Answers

  • Hi Viresh, I want to add to Casey's response below.  We have recently enabled active geo-replication on all database tiers (Basic, Standard and Premium) and we are retiring standard geo-replication.  Find out more here: https://azure.microsoft.com/en-us/documentation/articles/sql-database-geo-replication-overview/  

    Active geo-replication allows you to have up to 4 readable secondaries that can be used for (read) load balancing as well as disaster recovery.  An active readable secondary produced by active geo-replication is charged at 100% (i.e. is charged as a normal database, with no discount). Standard geo-replication, which is still available, produces as non-readable secondary as is charged at 75% of the normal cost.  When standard geo-replication is retired in April 2017 any non-readable secondaries will be upgraded to readable and then charged at 100%.

    Saturday, May 28, 2016 4:01 PM

All replies

  • Yes you will be charged an additional 75% of the primary database.

    https://azure.microsoft.com/en-us/pricing/details/sql-database/

    "Standard geo-replication creates an offline secondary database in a pre-paired Azure region within the same geographic area that is at least 500 miles away. Secondary standard geo-replication databases are priced at 0.75x of primary database prices. The cost of geo-replication traffic between the primary and the offline secondary is included in the cost of the offline secondary. Standard geo-replication is available for Standard and Premium tier databases."

    Friday, May 27, 2016 10:54 PM
  • Hi Viresh, I want to add to Casey's response below.  We have recently enabled active geo-replication on all database tiers (Basic, Standard and Premium) and we are retiring standard geo-replication.  Find out more here: https://azure.microsoft.com/en-us/documentation/articles/sql-database-geo-replication-overview/  

    Active geo-replication allows you to have up to 4 readable secondaries that can be used for (read) load balancing as well as disaster recovery.  An active readable secondary produced by active geo-replication is charged at 100% (i.e. is charged as a normal database, with no discount). Standard geo-replication, which is still available, produces as non-readable secondary as is charged at 75% of the normal cost.  When standard geo-replication is retired in April 2017 any non-readable secondaries will be upgraded to readable and then charged at 100%.

    Saturday, May 28, 2016 4:01 PM