April 16, 2012 at 11:13 am
Hi All,
What is the difference between Availability Group and Replica? I understand that availability group is a container for set of databases.
But, can someone please let me know what availability replica is? I have already read msdn article on alwayson but still confused a bit.
thanks.
April 18, 2012 at 9:09 am
An Availability group is a set of databases that is accessed through a specified virtual network name.
An availability replica is a copy of the databases in an availability group on a particular server.
Example:
SqlAlwaysOnGrp1 is the availability group.
MyWebAppDB.MyCompany.com is the Availability Group Listener (this is what clients connect to. its DNS record gets updated in case of a failover).
It could contain 3 availability replics: SqlAtlanta.MyCompany.com, SqlDallas.MyCompany.com and SqlNewYork.MyCompany.com
SqlAtlanta is the Primary Replica, Dallas and NewYork are Secondary Replicas.
April 18, 2012 at 9:49 am
karthik.catchme (4/16/2012)
Hi All,What is the difference between Availability Group and Replica? I understand that availability group is a container for set of databases.
But, can someone please let me know what availability replica is? I have already read msdn article on alwayson but still confused a bit.
thanks.
An Availability Replica is an instance of SQL Server 2012 that you want to participate in the Availability Group to receive availability databases.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply