建立 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

flyfox 發表在 痞客邦 PIXNET 留言(0) 人氣()