Microsoft SQL Server 数据库镜像语句:
SERVER
CREATE ENDPOINT DbMirroring
STATE=STARTED
AS TCP(LISTENER_PORT=)
FOR DATABASE_MIRRORING(ROLE=PARTNERENCRYPTION=SUPPORTED)
ALTER DATABASE AdventureWorks SET PARTNER=TCP://:
SERVER
CREATE ENDPOINT DbMirroring
STATE=STARTED
AS TCP(LISTENER_PORT=)
FOR DATABASE_MIRRORING(ROLE=PARTNERENCRYPTION=SUPPORTED)
ALTER DATABASE AdventureWorks SET PARTNER=TCP://:
见证服务器
CREATE ENDPOINT DbMirroring
STATE=STARTED
AS TCP(LISTENER_PORT=)
FOR DATABASE_MIRRORING(ROLE=WITNESSENCRYPTION=SUPPORTED)
ALTER DATABASE AdventureWorks SET PARTNER=TCP://:
执行下面的代码就可以将镜像服务器设为主体服务器主体服务器设置为镜像服务器:
USE MASTER
Go
ALTER DATABASE AdventureWorks SET PARTNER FAILOVER
Go
