top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How many replicas are maintained for each SQL Azure database?

+2 votes
385 views
How many replicas are maintained for each SQL Azure database?
posted Feb 26, 2014 by Avinash Shukla

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

For each database, three replicas are maintained for each database that one provisions. One of them is primary replica. All read/write happen on primary replica and other replicas are kept in sync with primary replica. If for some reason, primary goes down, other replica is promoted to primary. All this happens under the hood.

answer Mar 1, 2014 by Amit Kumar Pandey
...