Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (3/6) ...

  • Article

Create Outbound certificates on ZAGREB.sql

:connect ZAGREB

-- Activate DB Mirroring
DBCC TRACEON (1400)

-- DROP endpoint mirroring
-- DROP certificate BUDA_cert
-- DROP master key

CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<1_Strong_Password!>';
GO

USE master;
CREATE CERTIFICATE ZAGREB_cert
   WITH SUBJECT = 'ZAGREB certificate for database mirroring',
 START_DATE = '09/28/2005',
 EXPIRY_DATE = '09/28/2006'
GO

USE master;
SELECT * FROM sys.certificates;

SELECT name, role_desc, state_desc, connection_auth_desc, encryption_algorithm_desc FROM sys.database_mirroring_endpoints;
GO

CREATE ENDPOINT Mirroring
   STATE = STARTED
   AS TCP (
      LISTENER_PORT=5024
      , LISTENER_IP = ALL
   )
   FOR DATABASE_MIRRORING (
      AUTHENTICATION = CERTIFICATE ZAGREB_cert
      , ENCRYPTION = REQUIRED ALGORITHM RC4
      , ROLE = ALL
   );
GO

:!! del C:\backups\ZAGREB_cert.cer
BACKUP CERTIFICATE ZAGREB_cert TO FILE = 'C:\backups\ZAGREB_cert.cer';
GO

:!! copy \\ZAGREB\backups\ZAGREB_cert.cer \\BUDA\backups\ZAGREB_cert.cer
:!! copy \\ZAGREB\backups\ZAGREB_cert.cer \\PEST\backups\ZAGREB_cert.cer