6、设置主备同步
先在备机执行：
ALTER DATABASE [DB_NAME] SET PARTNER = ‘TCP://主机IP:5022‘;
再到主机执行：
ALTER DATABASE [DB_NAME] SET PARTNER = ‘TCP://备机IP:5022‘;
7、大功告成，这应该算是最简单的配置方法了吧。
SQL2008非域环境直接使用WINDOWS登录的镜像设置
标签：blog 登录 图片 color 简单 for bottom sql2008 tom
SQL2008非域环境直接使用WINDOWS登录的镜像设置
DROP ENDPOINT Endpoint_Mirroring
--GO
CREATE ENDPOINT Endpoint_Mirroring
STATE = STARTED
AS
TCP ( LISTENER_PORT=5022 , LISTENER_IP = ALL )
FOR
DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS NTLM ,
ENCRYPTION = REQUIRED ALGORITHM AES ,
ROLE = ALL );