1

I'm searching for advise with SharePoint database when using Always On availability group.

I have MSSQL server with 2019 Standard version and SharePoint 2019 Standard license. I wanna protect my DBs by availability groups.

I was searching but I couldn't find one official or integrate answer for question's.

How can I use basic availability groups on MSSQL to protect SharePoint databases? Is it supported solution by Microsoft? This solution (BAG) has any risk in usage?

0

I don't think it is good idea, as it has limitation of the only 1 database in the availability group. Their are limitation in SharePoint powershell commands, where you need multiple databases in the same group i.e Config/ admin. search service.

You can read this thread for more information: SharePoint and Always On Basic Availability Groups?

0

As Basic AGs can only protect a single database, it isn't very useful for SharePoint.

While Mirroring has been deprecated for quite a few versions but has yet to be removed.

SQL Enterprise with AlwaysOn Availability Groups would be the modern method of synchronization.

2
  • You have right, i know this but this is only option for me and that i ask here. I was hoping that somebody made this configuration and could help me.
    – Rademenes
    Mar 24 at 7:47
  • No, because Basic AGs just aren't fit for use or really compatible with SharePoint given it has a minimum of two databases (Config an Admin). Mar 24 at 17:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.