Sunday, July 16, 2017

During this example, different port used for as part of illustration. Different port number between AG and instance is not a requirement, it’s a best practice instead as one instance can support multiple AG groups.

Install SQL instance, configure port number, as well as enable for AlwaysOn

SQL01\AGINST1: port 2444, SQL02\AGINST4: port 2446, AG1: port 2447

--- Steps for SQL02\AGINST4 omitted

Configure AG1 (DB/translog backup is required)

I was able to resolve above error by a new translog backup/restore performed for this DB1.

Additional, it’s not possible to select instances on the same SQL Server Node as part of AG group replica.