Issue: Unable to failover RTCXDS database to mirror node.
Error message: WARNING: Cannot failover the database using manual failover.
When you invoke failover to mirror you may see message that ‘The database mirroring safety level must be FULL to manually failover database “rtcxds”.
You have change safety level to FULL in order to failover DB to mirror node.
You can resolve this using SQL query:
1. Login to SQL database server or farm and connect database.
2. Right click on “rtcxds” database and say new query.
3. Run below query.
ALTER DATABASE rtcxds SET PARTNER SAFETY FULL
You can use same query to any other database replaceing
Now failover database again using Lync PowerShell or using SQL studio / farm.
Invoke-CsdatabaseFailover –PoolFqdn “pool name” –DatabaseType User –NewPrincipal Mirror