Synchronize Logins (Jobs) in Microsoft SQL Server Always On Availability Groups
#mssqlserver #mssql #microsoft #giveback #community #hadr #dbatools
#automation
DBATools.io
https://docs.dbatools.io/Copy-DbaLogin
Powershell script samples are mentioned below
synchronize SQL Server logins to other replicas
Copy-DbaLogin -Source SQL01 -Destination SQL02 -Force -KillActiveConnection
synchronize SQL Server Agent Jobs to other replicas
Copy-DbaAgentJob -Source SQL01 -Destination SQL02
synchronize SQL Server Linked Servers to other replicas
Copy-DbaLinkedServer -Source SQL01 -Destination SQL02