Forum Discussion
Dean_Gross
Feb 18, 2018Silver Contributor
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?
- 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.
4 Replies
- Dean_GrossSilver ContributorThanks, that is what I was afraid would happen,
Also, please change your profile, we are all spo admins, knowing who we are chatting with makes the community stronger- 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.
- Dean_GrossSilver Contributor
Thanks for the confirmation. I trust your answer more than the previous one i received :)
- Deleted
Since adding the database also involves syncing with secondary replica server the failover switch always does a farm shutdown and restart.