-- 如果存在之前创建的旧端点，先删除
SELECT * FROM sys.endpoints;
DROP ENDPOINT [端点名称];
CREATE ENDPOINT Ticket_Mirroring
STATE = STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATABASE_MIRRORING (
AUTHENTICATION = CERTIFICATE master_cert,
ENCRYPTION = REQUIRED ALGORITHM AES,
ROLE = ALL
);
GO
-- 如果存在之前创建的旧端点，先删除
-- SELECT * FROM sys.endpoints;
-- DROP ENDPOINT [端点名称];
CREATE ENDPOINT Ticket_Mirroring
STATE = STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATABASE_MIRRORING (
AUTHENTICATION = CERTIFICATE slave_cert,
ENCRYPTION = REQUIRED ALGORITHM AES,
ROLE = ALL
);
GO
-- 如果存在之前创建的旧端点，先删除
-- SELECT * FROM sys.endpoints;
-- DROP ENDPOINT [端点名称];
CREATE ENDPOINT Ticket_Mirroring
STATE = STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATABASE_MIRRORING (
AUTHENTICATION = CERTIFICATE witness_cert,
ENCRYPTION = REQUIRED ALGORITHM AES,
ROLE = ALL
);
GO
SELECT
DB_NAME(database_id) AS database_name,
mirroring_role_desc,
mirroring_state_desc,
mirroring_partner_name,
mirroring_witness_name,
mirroring_safety_level_desc,
mirroring_witness_state_desc
FROM sys.database_mirroring
WHERE database_id = DB_ID('test');
GO
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对