建立 D 認證USE master
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'p@sswOrd'
GO
CREATE CERTIFICATE MirrorCertD
WITH SUBJECT = 'D MirrorCert'
GO
ALTER ENDPOINT Main
FOR DATABASE_MIRRORING (
AUTHENTICATION = CERTIFICATE MirrorCertD
, ENCRYPTION = REQUIRED ALGORITHM AES
, ROLE = ALL
)
GO
BACKUP CERTIFICATE MirrorCertD
TO FILE = 'D:\MirrorCertD.cer'
GO
-----------------------------------
USE master
匯 DM 認證
CREATE CERTIFICATE MirrorCertDM
AUTHORIZATION dbo
FROM FILE = 'D:\MirrorCertDM.cer'
GO
全站熱搜
留言列表