High Availability features supported by different SQL Server versions

The below table show High Availability features supported by different SQL Server versions which give SharePoint Administrator insight which options will be appropriated the option.

For SQL Server 2012

2

For SQL Server 2014

3

For SQL Server 2016 and higher version

4

AlwaysOn will be supported with standard edition but with some limitations:

  • Limited to two nodes only (a primary and a secondary server)
  • Like mirroring, you can’t read from the secondary, nor take backups of it
  • It is not appropriate for a SharePoint farm as it only supports a single database within the Basic Availability Group
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s