镜像
CREATE ENDPOINT AughtEightDagobahMirror
AUTHORIZATION sa
STATE = STARTED
AS TCP(LISTENER_PORT=5022,LISTENER_IP=ALL)
FOR DATA_MIRRORING
(ROLE =PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE,ENCRYPTION=REQUIRED ALGORITHM RC4)
--AughtEight 主体服务器,Dagobah是镜像服务器,Tatooine是见证服务器
USE master
GO
CREATE ENDPOINT AughtEightDagobahPrincipal
AS TCP(LISTENER_PORT=5022)
FOR DATA_MIRRORING(ROLE=PARTNER,ENCRYPTION=REQUIRED ALGORITHM RC4);
GO
CREATE LOGIN[AughtEight\DagobahSQL] FROM WINDOWS;
GO
CREATE LOGIN [AughtEight\TatooineSQL] FROM WINDOWS;
GO
GRANT CONNECT ON ENDPOINT::AughtEightDagobahPrincipal
to [AughtEight\TatooineSQL];
GRANT CONNECT ON ENDPOINT::AughtEightDagobahPrincipal
TO [AughtEight\DagobahSQL];
GO
--RUN on Dagobah
USE master
GO
CREATE ENDPOINT AughtEightDagobahMirror
AS TCP(LISTENER_PORT =5023)
FOR DATA_MIRRORING (ROLE=PARTNER,ENCRYPTION=REQUIRED ALGORITHM RC4);
GO
CREATE LOGIN [AughtEight\AughtEightSQL] FROM WINDOWS;
CREATE LOGIN [AughtEight\DagobahSQL] FROM WINDOWS;
GO
GRANT CONNECT ON ENDPOINT::AughtEightDagobahPrincipal
to [AughtEight\AughtEightSQL];
GRANT CONNECT ON ENDPOINT::AughtEightDagobahPrincipal
TO [AughtEight\DagobahSQL];
GO
--Run on Tatooine
USE master
GO
CREATE ENDPOINT AughtEightDagobahMirror
AS TCP(LISTENER_PORT =5024)
FOR DATA_MIRRORING (ROLE=WITNESS,ENCRYPTION=REQUIRED ALGORITHM RC4);
GO
CREATE LOGIN [AughtEight\AughtEightSQL] FROM WINDOWS;
CREATE LOGIN [AughtEight\DagobahSQL] FROM WINDOWS;
GO
GRANT CONNECT ON ENDPOINT::AughtEightDagobahPrincipal
TO [AughtEight\AughtEightSQL];
GRANT CONNECT ON ENDPOINT::AughtEightDagobahPrincipal
TO [AughtEight\DagobahSQL];
GO
摘自:《SQL SERVER2008 DBA 入门》