Manually fail over or fail back a Lync SQL mirrored database

-
In several cases you need to manually organize or switch databases on your mirror database/ SQL Server. Either after a reboot or simply some other issues.

The SQL queries are the most efficient solution and can be scheduled as well. But you need access to the SQL database. You can do this from remote, if you have the SQL Management Console installed

You need to execute a SQL QUERY as following:



You have to use and execute a SQL Query:

USE master;
ALTER DATABASE database_name SET PARTNER FAILOVER

database_name: name of the DB to fail over
Server where to execute: MUST be the primary database owner server, where the database is actually active

What I personally do is, I save SQLQuery on my Primary SQL and run this script every time I need to fail back the databases.

For those who think well, I could do this with Lync Management Shell. Sure you can do to.

Invoke-CsDatabaseFailover -PoolFQDN POOLFQDN -Databasetype "TYPE" -NewPrincipal "PRIMARY"

Where NewPrincipal is the Primary SQL (PRIMARY) or the Mirror SQL (MIRROR).

The Databasetype is the installed database associated with this SQL setup:
* Application
* Archiving
* CentralAdmin
* CentralMgmt
* Cls
* Edge
* Lyss
* Monitoring
* PersistentChat
* PersistentChatCompliance
* Provision
* Registrar
* User 


Author:

Comments

Post a Comment

Popular posts from this blog

How to hide users from GAL if they are AD Connect synchronized

-
Image
How to hide and un-hide users from Global Address List (GAL) in Exchange Online if they are AD Connect synchronized Hiding User from GAL isn't possible if those are synchronized form On-Premises Active Directory. The local AD is the leading system for all important attributes, like SMTP, UPN and hiding from GAL. Especially during a cross-tenant migration, you do not want to see not migrated user in the GAL. Those User aren't actively working until their cut-over day. Since the Exchange Online attribute  msExchHideFromAddressList s is an AD on-premises parameter, we have two possible ways hiding user in BME from GAL.   Modify the AD Connect for your teant with a custom rule, by using a extensionAttribute to set the HidefromGAL. In this rule, for users which have an entry in the extensionAttribute, hiding / un-hiding will be controlled by AD Connect This is the best option for Cross-Tenant Migration, if you run 2 or more AD Connect system We direct modif...
Read more

Cannot join external Lync Meeting: Lync Edge Server Single IP Address (Lync Edge Server Single IP Web Conferenceing Problem)

-
Image
Lync Edge Server FQDN and IP PORTS (Version 1.2, Update 26.11.2014) As we all know, we can configure Lync Edge Server in several way. 1) Single Edge Server with a SINGLE IP ADDRESS 2) Single Edge Server with MULTIPLE IP ADDRESSES (3x IPs) 3) Multiple Edge Server in a Pool, with MULTIPLE IP ADDRESSES (Zx 3 IPs) Regardless what we are going to configure, there are common / well-known TCP Port necessary making Lync work, which are: Access: Port: 443 and 5061 Conferencing: Port: 443 and (444) AV: Port: 443 (I have not listed other ports, e.g. STUN or the dynamic port range. This is not required for the topic discussed here) External FQDN with single IP address: What can we see here? If we are going to choose a single IP address, we would have TCP Port overlapping. Therefore the only way avoiding this is assigning other ports. Additionally we will also see and are reminded that Lync highly depends on DNS. If we have single IP, we must have use single, uniqu...
Read more

MFA with Guest Access and different tenants settings

-
Image
There is an update regarding MFA Multi Factor Authentication. If you are guest with a different Tenant, the MFA Settings are now reflecting the settings of all tenants in a different way. Each MFA setting is reflected and you can setup your MFA device as per tenant and the admin settings allow. Login to your Profile in Office 365/ Azure AD: https://account.activedirectory.windowsazure.com/r/#/profile or https://myapps.microsoft.com Go to your PROFILE: Sign in to https://myapps.microsoft.com Select your account name in the top right, then select profile. Select Additional security verification. If might be happen, your admin hast configured MFA, so you wouldn't see this menu. Simply switch the tenant to the guest tenant where you need to configure MFA. Once you go back to your profile and you will find the MFA device and other settings a usual:
Read more