Search This Blog

Monday, February 17, 2014

Lync SQL mirror troubleshooting

To move all DB back tpo the primary SQL run in the FrontEnd PowerShell 

Invoke-CsDatabaseFailover –PoolFQDN fepoolname.domain.loc –DatabaseType User –NewPrincipal primary -verbose

Invoke-CsDatabaseFailover –PoolFQDN fepoolname.domain.loc –DatabaseType User –NewPrincipal primary

Invoke-CsDatabaseFailover –PoolFQDN fepoolname.domain.loc –DatabaseType App –NewPrincipal primary

Invoke-CsDatabaseFailover –PoolFQDN fepoolname.domain.loc –DatabaseType CentralMgmt –NewPrincipal primary

Invoke-CsDatabaseFailover –PoolFQDN fepoolname.domain.loc –DatabaseType Monitoring –NewPrincipal primary

If Mirror is shown as suspended - log to current holder of primary SQL for this db and pass SQL query

ALTER DATABASE SET PARTNER RESUME


Then try again  Invoke-CsDatabaseFailover 

No comments: