Microsoft SQL Server 2005数据库镜像语句

来源:赛迪网  作者:Osborn
摘要:【赛迪网-IT技术报道】Microsoft SQL Server 2005数据库镜像语句:SERVER 1CREATE ENDPOINT DbMirroringSTATE=STARTEDAS TCP(LISTENER_PORT=5023)F……

【赛迪网-IT技术报道】Microsoft SQL Server 2005数据库镜像语句:

SERVER 1

CREATE ENDPOINT DbMirroring

STATE=STARTED

AS TCP(LISTENER_PORT=5023)

FOR DATABASE_MIRRORING(ROLE=PARTNER,ENCRYPTION=SUPPORTED)

ALTER DATABASE AdventureWorks SET PARTNER='TCP://192.168.5.106:5022'


SERVER 2

CREATE ENDPOINT DbMirroring

STATE=STARTED

AS TCP(LISTENER_PORT=5022)

FOR DATABASE_MIRRORING(ROLE=PARTNER,ENCRYPTION=SUPPORTED)

ALTER DATABASE AdventureWorks SET PARTNER='TCP://192.168.5.106:5023'


见证服务器

CREATE ENDPOINT DbMirroring

STATE=STARTED

AS TCP(LISTENER_PORT=5033)

FOR DATABASE_MIRRORING(ROLE=WITNESS,ENCRYPTION=SUPPORTED)

ALTER DATABASE AdventureWorks SET PARTNER='TCP://192.168.5.106:5033'


执行下面的代码就可以将镜像服务器设为主体服务器,主体服务器设置为镜像服务器:

USE MASTER

Go

ALTER DATABASE AdventureWorks SET PARTNER FAILOVER

Go

【相关文章】好搜一下
详解SQL Server执行动态SQL两种正确方式

详解SQL Server执行动态SQL两种正

动态SQL大家经常都会用到,它一般是根据用户输入或外部条件动态组合的SQL语句块…