Availability Group Vs Availability Replica

• karthik.catchme

  SSC Eights!

  Points: 818

  More actions

  April 16, 2012 at 11:13 am

  #392035

  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.

• SpringTownDBA

  SSCertifiable

  Points: 6917

  More actions

  April 18, 2012 at 9:09 am

  #1475399

  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.

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  April 18, 2012 at 9:49 am

  #1475431

  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"