Skip to main content
4 votes

Deny access to Sql Server replica when it becomes primary

the primary fails and the secondary becomes the primary; the reading load is not desired since it will effect mission-critical loads (that are transferred to the new primary). We can tolerate outage ...
SqlWorldWide's user avatar
  • 13.5k
1 vote

SQL Server Always On Availability Groups are green, but manual failover attempts consistently failing ("duplicate IP address", etc. in cluster logs)

In the scenario of an AG Listener Resource Group with multiple "Cluster IPs," you need to make sure that each Resource has only one possible owner!
Borik's user avatar
  • 227

Only top scored, non community-wiki answers of a minimum length are eligible