always on 2014

• Mad-Dog

  SSCertifiable

  Points: 6117

  More actions

  May 1, 2016 at 1:34 am

  #307060

  Hi,

  can i setup always on with 2 SQL 2014 standard edition with Windows 2012 R2?

  THX

• VastSQL

  SSC-Dedicated

  Points: 36121

  More actions

  May 1, 2016 at 2:05 am

  #1875786

  Mad-Dog (5/1/2016)

  ---

  Hi,

  can i setup always on with 2 SQL 2014 standard edition with Windows 2012 R2?

  THX

  Always On Failover Cluster Instances are supported but not Always on Availability Groups. Only Enterprise Edition supports AG.

  https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  May 1, 2016 at 9:48 am

  #1875796

  Synchronous Database Mirroring is your option on SQL 2014 Standard Edition.

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service