We have a SQL Server Enterprise 2017. I would like to get insights as to why our
SERVERPROPERTY('HadrManagerStatus')returns 1 even if Always On is not configured in this instance.
I have a local instance in my work machine that is a stand alone. When I run
SELECT SERVERPROPERTY('HadrManagerStatus') it returns
1 even if I have not set up Always On on this machine. Never have attempted to check the "Enable Always ON" box on the Service in the SQL server Configuration Manager.
I have setup this instance to be a publisher and a distributor for Replication. I have restored databases on this instance that the database were part of the availability databases.
I guess my question is, how does this
SERVERPROPERTY('HadrManagerStatus') evaluates? What conditions does it check?