文档库

最新最全的文档下载
当前位置:文档库 > sql mirror for XenDesktop Guide

sql mirror for XenDesktop Guide

文文: D:\technology\citrix\sql mirror\sql mirror for XenDesktop Guide 2013/1/15, /15, 16:21:41

Env:

sql(sql server2008R2):

Master:sqlnode88.demo.sbdc.local

Mirror:sqlnode87.demo.sbdc.local

witness:oavdijspdata.demo.sbdc.local

ctxddc1:sqlnode1.demo.sbdc.local

note:

a.Please confirm all the DDCs have installed before configure the sql mirror.

b.Don't not try to install the DDC and sqlserver in the same server,sql mirror

will not work normal.

c.Not need to configure the ODBC for the DDC

XenDesktop DDC prerequisite

1.All XenDesktop DDC work normally

2.Add Citrix XenDesktop DDC powershell

run command at DDC which you want to reconfig the DB as blow:

a.Click powershell

b.Add-PSSnapin Citrix*

3.Install Sql Server management studio with the correct version for you

operation system

a.Install SSMS(download it from Microsoft website)

b.confirm the 'sqlcmd' command can be run in the command line.

Reconfig sqlserver mirror process

1.Disconnect the XenDestkop DDC of the SqlServer

$controllers = Get-BrokerController | %{$_.DNSName}

foreach ($controller in $controllers) {

Write-Host "Disconnect controller $controller ..."

Set-ConfigDBConnection –DBConnection $null –AdminAddress $controller

Set-HypDBConnection –DBConnection $null –AdminAddress $controller

Set-AcctDBConnection –DBConnection $null –AdminAddress $controller

Set-ProvDBConnection –DBConnection $null –AdminAddress $controller

Set-PvsVmDBConnection –DBConnection $null –AdminAddress $controller

Set-BrokerDBConnection –DBConnection $null –AdminAddress $controller

}

2.mirror DB

please refer http://www.wendangku.net/doc/49f141f7910ef12d2af9e778.html /en-us/library/ms190941.aspx

After mirror the DB,please verify the mirrir DB is ok.

3.Add the mirror server for DDC

$mirrorServer = 'sqlnode88.demo.sbdc.local'

$dbName = 'CitrixXenDesktopDB'

foreach ($controller in $controllers) {

第 1 页

免费下载Word文档免费下载: sql mirror for XenDesktop Guide

(共4页)