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

CREATE CERTIFICATE MirrorCertDW
  WITH SUBJECT = 'DW MirrorCert'
GO

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

BACKUP CERTIFICATE MirrorCertDW
  TO FILE = 'D:\MirrorCertDW.cer'
GO

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

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

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