Database Configuration for DR SharePoint Server 2019

Question

SharePoint 2019 Farm consists of two SharePoint Servers using Always On High Availability. Now DR Farm needs to be configured in another location. Is it possible to use another replica of Always On High availability Group ? Or Stand Alone SQL Server ? What is recommended ?

If we are using Stand Alone SQL Server 2017, what is the best option for data replication ?

Answer 1

Is it possible to use another replica of Always On High availability Group ?

Yes for the databases, but SharePoint requires the setup of a new farm on the DR side IIRC where you import the sites in the databases (I can't remember if this changed or not).

If we are using Stand Alone SQL Server 2017, what is the best option for data replication ?

If you're looking for a purely SQL Server solution, then I would do as you've already stated and look into using availability groups.

Answer 2

You should add an asynchronous node as your 3rd leg. As for the stand alone question, you can use SQL Mirroring, though that is considered deprecated with AOAG as the replacement.

I'd recommend looking through https://learn.microsoft.com/en-us/sharepoint/administration/high-availability-and-disaster-recovery-concepts. SharePoint and DR is a complicated subject with various pitfalls.