I have 3 SQL Servers – SQL01, SQL02 and SQL03.
SQL01 has 2 databases – SQL01_DB1 and SQL01_DB2.
SQL02 has 3 databases – SQL02_DB1, SQL02_DB2 and SQL02_DB3.
I want to set up an Always On High Availability Clusters to do the following:
SQL01 will be a Primary and SQL02 will be a Read-Only Secondary for SQL01_DB1 and SQL01_DB2.
SQL02 will be Primary and SQL03 will be secondary for SQL02_DB1, SQL02_DB2 and SQL02_DB3.
Is this possible to accomplish?
I am in a research stage right now