Forum Discussion

Dean_Gross's avatar
Dean_Gross
Silver Contributor
Feb 18, 2018
Solved

Adding SP DB to availability group

when a sharepoint 2013 database is added to SQL Server Availability Group, does that process have any affect on the availability of the SP farm?
sharepoint server
  • Trevor Seward's avatar
    Trevor Seward
    Feb 19, 2018
    If your SharePoint farm is already pointing at the AG endpoint, then no adding a database to the AG does not cause the database to become unavailable.
Deleted's avatar
Deleted
Feb 18, 2018

Since adding the database also involves syncing with secondary replica server the failover switch always does a farm shutdown and restart.