SQL Server 2005数据库镜像配置脚本示例

　　AS tcp (listener_port = 5022)

　　for database_Mirroring (role = partner,encryption=supported);

　　go

以下为引用的内容：

CREATE ENDPOINT Db_MirroringEP

　　AS TCP (LISTENER_PORT = 5022)

　　FOR DATABASE_MIRRORING (ROLE = PARTNER, ENCRYPTION = SUPPORTED);

　　GO

　　ALTER ENDPOINT Db_MirroringEP STATE = STARTED

　　GO

以下为引用的内容：

CREATE ENDPOINT Db_MirroringEP

　　AS TCP (LISTENER_PORT = 5022)

　　FOR DATABASE_MIRRORING (ROLE = WITNESS, ENCRYPTION = SUPPORTED);

　　GO

　　ALTER ENDPOINT Db_MirroringEP STATE = STARTED

　　GO

　　go

　　grant connect on endpoint::"DB_MirroringEP" to "SOMODESQL/sqladmin"

　　go

　　FROM DISK = 'C:/AdventureWorks.bak'

　　WITH NORECOVERY

　　GO

alter database AdventureWorks

set partner = N'TCP://MIR-A.somodesql.com:5022'

GO

alter database AdventureWorks

set partner = N'TCP://MIR-B.somodesql.com:5022'

GO

ALTER DATABASE AdventureWorks

SET WITNESS = N'TCP://MIR-W.somodesql.com:5022'

GO

use master

go

SELECT * FROM sys.database_mirroring_endpoints

SELECT * FROM sys.database_mirroring WHERE database_id =

(SELECT database_id FROM sys.databases WHERE name = 'AdventureWorks')