MSSQL Always ON 배치 등록 방법

declare @p int;
set @p = (select master.sys.fn_hadr_is_primary_replica (‘DBNAME‘))

if (@p = 1)
begin

exec PROC-NAME

end

DECLARE @primary_replica nvarchar(128), @local_replica_name nvarchar(128), @CheckNoOnlineCount int

SELECT @primary_replica = B.primary_replica, @local_replica_name = D.replica_server_name
FROM sys.availability_groups AS A
INNER JOIN sys.dm_hadr_availability_group_states AS B ON B.group_id = A.group_id
INNER JOIN sys.dm_hadr_availability_replica_states AS C ON C.group_id = A.group_id
INNER JOIN sys.availability_replicas AS D ON D.group_id = C.group_id AND D.replica_id = C.replica_id
WHERE A.name LIKE ‘DBSVR-AG‘ AND C.is_local = 1

SELECT @CheckNoOnlineCount = COUNT(*)
FROM sys.availability_groups AS A
INNER JOIN sys.dm_hadr_availability_replica_states AS B ON B.group_id = A.group_id
INNER JOIN sys.dm_hadr_database_replica_states AS C ON C.group_id = B.group_id AND C.replica_id = B.replica_id
WHERE A.name LIKE ‘DBSVR-AG‘ AND B.is_local = 1 AND C.database_state_desc < > ‘ONLINE’

IF @primary_replica = @local_replica_name AND @CheckNoOnlineCount = 0
BEGIN
PRINT ‘Go to the next step.’
END
ELSE
BEGIN
RAISERROR (‘Do not go to the next step.’, 16, 1)
END