Secondary replica offline SQL Availability Group
In a SQL 2014 Availability Group, all the databases on the secondary replica were showing Not Synchronizing. All the tricks to resume synchronizing failed. I tried to add another database and synchronize that one. It failed.
The root cause was the DNS record for the SQL server disappeared.
Solution was ipconfig /registerdns from an elevated command prompt.
The root cause was the DNS record for the SQL server disappeared.
Solution was ipconfig /registerdns from an elevated command prompt.
Comments