1.停止当前镜像(如果在源头有日志收缩等操作,必须停掉)
alter database database_name
set partner off
2.删除当前endpoint节点
drop endpoint [Endpoint_Mirroring]
3.按给定的账号,重建endpoint节点
CREATE ENDPOINT [Endpoint_Mirroring]
AUTHORIZATION [idc5173/sqlservice]
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM RC4)
4.重新做起镜像
在备机上运行:
ALTER DATABASE database_name SET PARTNER = 'TCP://主机IP:5022';