HomeAzure SQL DatabaseHA/DR for Azure SQL Database

Comments

HA/DR for Azure SQL Database — 3 Comments

  1. With regard to Active Geo-Replication, is this a decent approach for HA in a Data Warehouse environment. Obviously at DW load time, the number of inserts/updates is high, outside of that it wouldn’t need to do anything. Volumes are reasonable but not quite large enough for Azure DW.

    Would the replication be adversely affected? Is there any way we can determine how long it might take to replicate a large and condensed set of inserts/updates?
    What would be an alternative?

    Lots of questions..any info would be really helpful – thanks

    • Hi Steve,
      Azure SQL Database has a max size of 1TB. So if your DW is under that limit, you can use it and geo-replication will work great and only take a few seconds to catch up.

  2. Pingback:Microsoft 70-473 Exam Resources – bitScry

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>