【SQL Server点滴积累】Setup SQL Server 2008 Database Mirror (二)

【SQL Server点滴积累】Setup SQL Server 2008 Database Mirror (一)-CSDN博客今天分享SQL Server 2008 R2搭建数据库镜像(Database Mirror)https://blog.csdn.net/ncutyb123/article/details/139749117?spm=1001.2014.3001.5501本篇Blog基于以上Blog步骤进行SQL Server 2008 R2数据库镜像(Database Mirror)的搭建

记得要把用于存放认证文件的DB-Mirror文件夹做共享

本文提供了配置过程中所需的所有SQL脚本，请自行下载

Setup SQL Server 2008 Mirror

1. Software  Environment

Principal Server:  10.7.30.18    D:\DB-Mirror   (share)

Mirror Server:    10.7.30.84    C:\DB-Mirror   (share)

Witness Server:   10.7.30.201   C:\DB-Mirror   (share)

   2.Configure Details

1.18-1-CreateCertOnPrincipal

2.18-2-CreateEndPointOnPrincipal

3.84-1-CreateCertOnMirror

4.84-2-CreateEndPointOnMirror

5.201-1-CreateCertOnWitness

6.201-2-CreateEndPointOnWitness

交叉拷贝保存认证文件，确保每台服务器的DB-Mirror文件夹中都有3份认证文件

7.18-3-Principal_CreateLoginAndGrant

8.84-3-Mirror_CreateLoginAndGrant

9.201-3-Witness_CreateLoginAndGrant

10.18-4-BackupDatabase

11.18-5-BackupLogPrincipal

12.84-4-RestoreDatabase

13.84-5-RestoreLogOnMirror

14.84-6-SetupMirrorServer

15.18-6-SetupPrincipalServer

16.18-7-SetupWitnessServer

最后，恭祝各位使用愉快！