flyfox

建立 DM 認證USE master
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'p@sswOrd'
GO

CREATE CERTIFICATE MirrorCertDM
  WITH SUBJECT = 'D MirrorCert DM'
GO

ALTER ENDPOINT Main
  FOR DATABASE_MIRRORING (
    AUTHENTICATION = CERTIFICATE MirrorCertDM
    , ENCRYPTION = REQUIRED ALGORITHM AES
    , ROLE = ALL
  )
GO

BACKUP CERTIFICATE MirrorCertDM
  TO FILE = 'D:\MirrorCertDM.cer'
GO
--------------------------------------
USE master
匯 D 認證
CREATE CERTIFICATE MirrorCertD
  AUTHORIZATION dbo
  FROM FILE = 'D:\MirrorCertD.cer'
GO