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

  • Article

Create Outbound certificates on PEST.sql

:connect PEST

-- Activate DB Mirroring
DBCC TRACEON (1400)

-- DROP endpoint mirroring
-- DROP certificate PEST_cert
-- DROP master key

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

USE master;
CREATE CERTIFICATE PEST_cert
   WITH SUBJECT = 'PEST 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 PEST_cert
      , ENCRYPTION = REQUIRED ALGORITHM RC4
      , ROLE = ALL
   );
GO

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

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