SQL Server 2005镜像构建手册

核心提示： 1、创建证书（主备可并行执行）--主机执行：1USE master;2create MASTER KEY ENCRYPTION BY PASSWORD = ’killkill’;3create CERTIFICATE HOST_A_cert WITH SUBJECT

1、创建证书（主备可并行执行）

--主机执行：

1USE master;

2create MASTER KEY ENCRYPTION BY PASSWORD = ’killkill’;

3create CERTIFICATE HOST_A_cert WITH SUBJECT = ’HOST_A certificate’ ,

4START_DATE = ’01/01/2008’;

5

--备机执行：

1USE master;

2create MASTER KEY ENCRYPTION BY PASSWORD = ’killkill’;

3create CERTIFICATE HOST_B_cert WITH SUBJECT = ’HOST_B certificate’,

4START_DATE = ’01/01/2008’;

5

2、创建连接的端点（主备可并行执行）

--主机执行：

1create ENDPOINT Endpoint_Mirroring

2STATE = STARTED

3AS

4TCP ( LISTENER_PORT=5022 , LISTENER_IP = ALL )

5FOR

6DATABASE_MIRRORING

7( AUTHENTICATION = CERTIFICATE HOST_A_cert , ENCRYPTION = REQUIRED ALGORITHM AES , ROLE = ALL );

8

--备机执行：

1create ENDPOINT Endpoint_Mirroring

2STATE = STARTED

3AS

4TCP ( LISTENER_PORT=5022 , LISTENER_IP = ALL )

5FOR

6DATABASE_MIRRORING

7( AUTHENTICATION = CERTIFICATE HOST_B_cert , ENCRYPTION = REQUIRED ALGORITHM AES , ROLE = ALL );

8

3、备份证书以备建立互联（主备可并行执行）

--主机执行：

1BACKUP CERTIFICATE HOST_A_cert TO FILE = ’D:SQLBackupHOST_A_cert.cer’;

--备机执行：

1BACKUP CERTIFICATE HOST_B_cert TO FILE = ’D:SQLBackupHOST_B_cert.cer’;