Azure SQL Database Continued

• Azure SQL Replications and Failovers
  • Replication is a technique where data gets replicated across other database.
  • Replication is used to mitigate performance issues by redirecting all the reads from secondary database and all the write operations from primary database.
  • Read operations are also used for Analytics.
  • Lets create an Azure SQL Database
    
  • Now lets create a replica
    
    
    
  • Replications are of two types
    • synchronous Replications
    • Asynchronous Replications
  • Azure supports autofailover using failover groups which can be configured on server