SQL Server复制情况下的高可用方案（一）镜像+复制

sonyet 发表于 2017-12-13 23:46:45

　　
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'
　　
SELECT * FROM sys.symmetric_keys
　　

　　
CREATE CERTIFICATE cert_3_100
　　WITH SUBJECT = 'HOST_A certificate for database mirroring',
　　EXPIRY_DATE = '1/1/2020'
　　
SELECT * FROM sys.certificates ;
　　

　　
CREATE ENDPOINT master_instance
　　STATE = STARTED
　　AS TCP (
　　LISTENER_PORT=5022
　　, LISTENER_IP = ALL
　　)
　　FOR DATABASE_MIRRORING (
　　AUTHENTICATION = CERTIFICATE cert_3_100
　　, ENCRYPTION = REQUIRED ALGORITHM AES
　　, ROLE = ALL
　　)
　　
SELECT name , role_desc , state_desc , connection_auth_desc , encryption_algorithm_desc
　　FROM sys.database_mirroring_endpoints
　　

　　
BACKUP CERTIFICATE cert_3_101 TO FILE = 'd:\cert_3_100.cer';
　　
GO

页: [1]

运维网's Archiver

SQL Server复制情况下的高可用方案（一）镜像+复制