Monday, September 10, 2012

Failover\Fallback SQL Mirror in Lync Server 2013

NOTE: The following post is based on Lync Server 2013 Preview. Procedures and screenshots are subject to change when Lync Server 2013 is RTM.

In my previous post, I described how to add a SQL mirror to your back-end database for SQL high availability.  In this post, I will describe how to failover and then fallback the SQL databases between the mirror.

Before failing over the SQL mirror, you need to determine whether or not your back-end database is hosting the Central Management Store (CMS) database.  You can determine this by running the following command:

Get-CsService –CentralManagement

Lync 2013 - SQL M failover - get-csservice

If the output shows the pool that you are failing over the back-end for then you must failover the CMS database.  In my lab I have all databases as part of the mirror configuration: User, CMS, Archiving, Monitoring, Apps, PersistentChat, PersistentChatCompliance:

Primary SQL Node:

Lync 2013 - SQL M failover - pricipal

Mirror SQL Node:

Lync 2013 - SQL M failover - mirror

You can also check the state of your mirror status by running the following:

Get-CsDatabaseMirrorState –PoolFQDN pool01.w15lab.local –DatabaseType User

Lync 2013 - SQL M failover - get-mirrorstate user

The supported –DatabaseType values are: App, Archiving, CentralMgmt, Monitoring, Provision, User, PersistentChat, PersistentChatCompliance

I need to run the following commands to failover all databases:

Invoke-CsDatabaseFailover –PoolFQDN pool01.w15lab.local –DatabaseType User –NewPrincipal mirror

Lync 2013 - SQL M failover - invoke-failover user

Now I run the similar command for the rest of my database types:

Invoke-CsDatabaseFailover –PoolFQDN pool01.w15lab.local –DatabaseType App –NewPrincipal mirror

Invoke-CsDatabaseFailover –PoolFQDN pool01.w15lab.local –DatabaseType CentralMgmt –NewPrincipal mirror

Invoke-CsDatabaseFailover –PoolFQDN pool01.w15lab.local –DatabaseType Archiving –NewPrincipal mirror

Invoke-CsDatabaseFailover –PoolFQDN pool01.w15lab.local –DatabaseType Monitoring –NewPrincipal mirror

Invoke-CsDatabaseFailover –PoolFQDN labad03lyse01.w15lab.local –DatabaseType PersistentChat –NewPrincipal mirror (note that my persistent chat pool is my Standard Edition server)

Invoke-CsDatabaseFailover –PoolFQDN labad03lyse01.w15lab.local –DatabaseType PersistentChatCompliance –NewPrincipal mirror (note that my persistent chat pool is my Standard Edition server)

After all commands have been executed, I can look at my SQL nodes again and see that my mirror node now has the active database:

Primary SQL Node:

Lync 2013 - SQL M failover - primary - post failover

Mirror SQL Node:

Lync 2013 - SQL M failover - mirror - post failover

When you are ready to fallback to the primary SQL node, just run the same commands but change the –NewPrincipal parameter to “primary”

Invoke-CsDatabaseFailover –PoolFQDN pool01.w15lab.local –DatabaseType User –NewPrincipal primary

Lync 2013 - SQL M fallback- invoke-failover user

This post describes how to manually fail your mirror databases over to the secondary SQL node and then fall back.


  1. if any automatic failover occurs, when the reason for the failover is corrected, will the DBs fail back to primary automatically? Thank you, very nice article.

    1. I have the same query on this. When using a witness for auto failover will it fall back to primary without intervention when the primary node is back up and synchronisation is complete

    2. No, even with a witness there is no auto fail back to the primary. You need to either manuallyl failover the databases back to the primary or restart the mirror node to fail back to primary.

  2. Here's an interesting point to consider while you are in failover:

  3. تعرفوا على المزيد عن شركة صيانة كاريير الموثقة عالميا و احصل من خلالها على شهادات ضمان على خدمات الصيانة للتواصل عبر

  4. تتم خدمات التنظيف فى افضل شركة تنظيف بالمدينة المنورة شركة فرسان الخليج على ايدى مجموعة من العمالة متخصصة فى تنفيذ عمليات التنظيف وتنظيف الاماكن الصعب الوصول اليها باسهل الطرق

  5. خطط فى خدمات اشهار مواقع ستجدوها فى شركة سوقني نحن نقوم بوضع خطط وحملات تسويقية مميزة باقل الاسعار لتسويق موقعك

  6. علينا الحفاظ على مواسير الصرف الصحى و القيام بعمليات الصيانة فى خدمة كشف تسربات المياه فى شركة امتار للتواصل عبر

  7. احصل على بودي جارد بالمواصفات التى تريدها عن طريق شركات الامن و الحراسات التى تقدم لك ما تريدة للتواصل عبر

  8. نقل الاثاث كبير الحجم امرا صعب و يمثل خطر على عفش منازلنا ولكن اذا اتصلت ب شركة نقل اثاث بالمدينة المنورة فلا داعى للقلق على عفشك للتواصل عبر

  9. Online Assignment Help cheap by expert writers to secure good grades, Allassignmenthelp provides professional assignment help in various subjects for students studying in colleges and universities across UK, USA, New Zealand, and Canada. We deliver quality solutions for assignments in over 100 subjects. Our customer support department is online by expert writers online 24/7 Feel free to contact.

  10. I am a normal visitor of your blog and appreciate you taking the time to maintain the excellent site. I’ll be a frequent visitor for a long time. Proofreading Services

  11. Thanks for sharing the inexorable articles on the web . If you guys unable to tackle together with your academic assignment and need online instant assignment help australia service then hire dissertation essay writer.

  12. Duplicate transactions in Quicken is one of the most common errors among the users. This error is commonly used by small and mid-sized businesses. Being a user-friendly tool with the amazing features, there can be some issues associated to Quicken transactions. If you are not able to solve Duplicate transactions in quicken, you can talk directly to our live Quicken professionals to get instant help for this issue. We work reliably as a successful third party Quicken support company, and providing live Quicken support services for online Quicken users in very nominal charges. Our live Quicken experts are also comfortably available to provide immediate solutions for any type of errors.
    quicken rental property manager
    delete quicken cloud data
    Quicken Error ol-393-a
    Quicken Print Checks

  13. We are a top-leading, most trustworthy and self-governing third party QuickBooks support provider, which is providing the dedicated and excellent QuickBooks support services for our valued customers. When you attempt to access a web-page from QuickBooks program, you can experience QuickBooks script error . This error takes place when the commands can’t be executed rightly due to some program problems. Our trained QuickBooks professionals are smartly known for solving this error within a few seconds. Our QuickBooks professionals have the skills to recognize the main reasons of this error and provide the appropriate solutions for solving this error immediately.
    QuickBooks Error 6000
    quickbooks install diagnostic tool
    QuickBooks error 12007
    QuickBooks error 3371
    QuickBooks install diagnostic tool

  14. Use Finance assignment help to finish your finance or accounting papers without messing yourself. You will get assured solutions to your numerical questions within your defined date or time.
    Accounting assignment help
    capital budgeting assignment help

  15. Get the best captain america quotes here and read the best attributes of the captain Marvel here. captain america quotes

  16. thank you for information and helpful for everyone

    หวยยี่กี pantip

  17. How Our PhD. Experts Help Students To Rewriting Their Essay, who dont know how to write an essay.

  18. Thanks for sharing such an informative post.
    In any small industry, Managing Accounting Reports through QuickBooks Pro Version is simply comes with lots of accounting programs in a systematic manner. This a luxury features that helps to manage and calculates all your accounting reports as regularly. QuickBooks Desktop Pro is an accounting and bookkeeping software that helps to manage all your issues QuickBooks Pro most Common Error and Troubleshooting in a well mannered.

  19. Get the best and famous good night quotes for all like him, her, wife, husband, entrepreneur etc. good morning quotes for him

  20. My Assignment Services will help you in making the decisions as per your requirement. They will provide you with many benefits. The essays and assignments will have relevant information. No need to worry anymore. If your workload is piling up and has to submit your assignment in less time, then you can get Math Homework Help from My Assignment Services. This will help you in setting up your priorities.

  21. Welcome to the online gambling website. online casino

    ufabet com


  22. We are providing CDR Writers Australia. If anybody requires to get CDR For Australia Immigration for successful visa migration approval in Australia, communicate with our experts and visit our website CDRAustralia.Org.
    Mail us at: Contact@CDRAustralia.Org.

    Our other Services:
    RPL Writing Services
    NER work experience statement
    Competency Based Assessment For Papua New Guinea
    RPEQ Australia

  23. According to a new report by Expert Market Research, ‘Ship Spares and Equipment Market Size, Share, Price, Trends, Growth, Report and Forecast 2021-2026’, the Ship Spares and Equipment Market size was valued at USD XX million in 2020 and is predicted to register a CAGR of XX% from 2021 to 2026.

    Download a free Sample Report : Ship Spares and Equipment Market Size, Report & Forecast

  24. Malaysian students who are unable to write assignments search for the assignment help websites who can assist them in writing the assignment. Assignment writing experts are experienced academic writers; all the writers have a Ph.D. and master's degree in the relevant discipline. 100% Plagiarism free and entirely original assignments are delivered by the experts. It saves the time of the students which they can use for other activities. There are times when the students don’t have enough knowledge of the subject and topic of the assignment then also assignment help can be useful.

  25. Do you need Statistics assignment help? No more worry, Best Assignment Experts is nowhere to help you out with statistics problems. Get the best quality and satisfying Statistics assignment help from experts, scholars all 24*7 hours day and night. We offer customized plagiarism-free, well-framed, and well-referenced assistance at a very reasonable price.
    Statistics Assignment Help

  26. Search and discover your HP Printer's best programming and driver on our site. In the event that you have any issues while running Windows 10 with your 123 HP Setup printer, you can use HP Print and Scan Doctor to investigate and resolve the issue. [ Software and Drivers] 123 hp com setup HP Experts on this site will help you screen your system by prescribing the right programming and driver to stay up with the latest. 123 setup Adhere to bit by bit directions accommodated extra subtleties on 123 hp com/setup Take from the shipment box the 123 HP Setup Printer and spot it on a level unbending surface. Eliminate from it the bundling materials. Remembered for the bundle are the system handbook, power rope, USB link and CD-establishment driver and Ink cartridges. Eliminate from the devices all tapes and pressing materials. The devices is user near keep the printer's parts from moving during shipment. Keep the transportation box and other reused pressing materials to the side. Pull the information and yield plate 123 hp com setup printer.

  27. As we all know QuickBooks is accounting software designed to help you and manage financial information. Our Certified QuickBooks ProAdvisors® can assist you with QuickBooks installation, implementation, Integration and troubleshooting.
    Reinstall QuickBooks for Windows Using Clean Install | Troubleshoot Quickbooks 3000 status code errors | Fix QuickBooks Error 6000 80

  28. Looking to Assignment help? Myassignmenthelp provides best essay help and homework help services for student in USA. We have been catering to the brand alliances needs of the students.

    Our myob assignment help is here to wipe out all your dilemmas. Whenever you get stuck between your assignments, our professionals are just an approach away. Sometimes when you lack the time to complete an assignment, our essay help services fabricate matchless performance.