【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
- 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
最后，恭祝各位使用愉快！
