Tag: Availability Groups
This tag groups together all articles and posts related to Always On Availability Groups (AG).
-
dutyDBA Case Files #1 – Unable to change the database owner on secondary replicas to sa
This case notes is from a real world incident, where a DBA account could not be dropped because it owns the databases on an Always On secondary replica. I investigate how it happened and show you how to resolve it, and prevent it from happening again.
-
Script to generate the setspn commands required to create/register SPNs for Always On & standalone SQL Server service accounts
This article offers a script that generates all the necessary setspn commands required to create the SPNs for Always On and standalone SQL Server instance service accounts. Once you run these setspn commands, the SPNs get created and registered in the Active Directory (AD)
-
In a distributed Always On AG setup, how to check the database synchronisation and health status across all nodes/replicas?
This post shows you how to check the synchronisation and health status of your databases and replicas across a distributed Always On setup. The built-in Always On dashboard does not show this information for distributed Always On setups.
-
SQL Server Orphan Users and Logins – how to prevent and manage them, and the gotchas to be aware of
This article discusses what are SQL Server orphan user and logins, how to prevent users and logins getting orphanned, and how to manage them. It also talks about the security risks associated with orphan AD/Windows groups.
Latest Articles
