Microsoft SQL Server 2005数据库镜像语句

2008-07-18 06:17:35  編輯來源:互聯網  简体版  手機版  評論  字體: 小|中|大

 

 

　　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

 

 

 

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