Can I do a combination of SQL Server Basic availability groups with SQL Replication?

1 vote

0 answers

57 views

replication sql-server-2016 basic-availability-groups

                          I need to use SQL Server Standard 2016 to keep the costs low but achieve HA. In addition we need to have two Read nodes for reporting purposes. I am wondering if I can use SQL Server Replication to get data for the two Read nodes. Is it possible to have this setup? What kind of issues this kind of setup may have down the road? 
                        

Asked by Madi (11 rep)

Apr 3, 2020, 10:34 PM

Can I do a combination of SQL Server Basic availability groups with SQL Replication?

Related Questions