Create database mirroring without join AD

最新推荐文章于 2019-12-12 13:30:35 发布

仙仙熊

最新推荐文章于 2019-12-12 13:30:35 发布

阅读量135

点赞数

分类专栏： MS_SQL_MIRRORING

本文链接：https://blog.csdn.net/weixin_39392627/article/details/85719081

版权

MS_SQL_MIRRORING 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

env: Windows server 2008R2
SQL Server 2008R2

在沒有AD環境下建立database mirroring
mirror資料庫RESTORE NORECOVERY 或STANDBY且witness與principal不可置於同一SERVER。
Server1:WIN-NWRNBEAWNNP
Server2:WIN-JEA7UQF4MLS

1.調整SQL Server, SQL Agent服務帳號
很多非網域SQL Server建立database mirroring都是用憑證建立
這裡不使用憑證。
將2台SQL Server, SQL Agent服務帳號都使用同一個帳號密碼

2.要做database mirroring的db復原模式設定為full
command:

ALTER DATABASE [DB] SET RECOVERY FULL

3.在SQL Server建立database 端點，port:5024
command:

--On Server1
create endpoint [mirroring] 
authorization [WIN-NWRNBEAWNNP\administrator]
state=started
as tcp (listener_port=5024) 
for data_mirroring (role=partner,
authentication = windows negotiate, 
encryption=required algorithm rc4)
go


--On Server2
create endpoint [mirroring] 
authorization [WIN-JEA7UQF4MLS\administrator]
state=started
as tcp (listener_port=5024) 
for data_mirroring (role=witness,
authentication = windows negotiate, 
encryption=required algorithm rc4)
go

4.建立端點完畢後，分別啟用端點
command:

alter endpoint [mirroring] state=started
go

5.分別在secondary, primary執行database mirroring指令
command:

On secondaey
alter database mirror set partner = 'tcp://WIN-NWRNBEAWNNP:5024'
go

On primary
alter database mirror set partner = 'tcp://WIN-JEA7UQF4MLS:5024'
go

沒有錯誤就是順利完成。