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.

113 comments:

  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.

    ReplyDelete
    Replies
    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

      Delete
    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.

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

    http://social.technet.microsoft.com/wiki/contents/articles/26976.lync-server-2013-control-panel-issue-where-adminuihost-only-tries-primary-sql-host-cannot-find-appropriate-url-with-diagnosis.aspx

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

    http://carriermaintenance.com

    ReplyDelete
  4. تتم خدمات التنظيف فى افضل شركة تنظيف بالمدينة المنورة شركة فرسان الخليج على ايدى مجموعة من العمالة متخصصة فى تنفيذ عمليات التنظيف وتنظيف الاماكن الصعب الوصول اليها باسهل الطرق
    http://www.forsan-elkhaleg.com/17/Cleaning-company-in-Madinah

    ReplyDelete
  5. خطط فى خدمات اشهار مواقع ستجدوها فى شركة سوقني نحن نقوم بوضع خطط وحملات تسويقية مميزة باقل الاسعار لتسويق موقعك
    http://www.swaqny.com

    ReplyDelete
  6. علينا الحفاظ على مواسير الصرف الصحى و القيام بعمليات الصيانة فى خدمة كشف تسربات المياه فى شركة امتار للتواصل عبر
    https://amtar-ksa.com/%D9%83%D8%B4%D9%81-%D8%AA%D8%B3%D8%B1%D8%A8%D8%A7%D8%AA-%D8%A7%D9%84%D9%85%D9%8A%D8%A7%D9%87/

    ReplyDelete
  7. احصل على بودي جارد بالمواصفات التى تريدها عن طريق شركات الامن و الحراسات التى تقدم لك ما تريدة للتواصل عبر
    http://www.guards-security.com/

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

    http://www.forsan-elkhaleg.com/20/Moving-furniture-company-in-Madinah

    ReplyDelete
  9. 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.

    ReplyDelete
  10. 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
    quicken-error-code-163

    ReplyDelete
  11. 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

    ReplyDelete
  12. 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.

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

    ReplyDelete
  14. 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

    ReplyDelete
  15. 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.

    ReplyDelete
  16. 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

    ReplyDelete
  17. 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.

    ReplyDelete
  18. 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.

    ReplyDelete
  19. If you want assignment help service in Singapore. You can get an assignment writing service from Great Assignment Help in Singapore. We provide assignment help for any subject. For more information, you can visit our website.

    ReplyDelete
  20. Want to fix the Quickbooks error 1904 but before you fix it, consider the windows should be updated on all machines that are used in a multi-user environment.

    ReplyDelete
  21. quickbooks tool hub users sometimes face some errors due to many reasons such as technical glitches,human intervention,etc. Earlier when this tool was not released, users had to download and diagnose all the errors individually.

    ReplyDelete
  22. Looking for essay writing help services? Myassignmenthelp provides best myob essay help services for student in USA. We have been catering to the homework help needs of the students.

    ReplyDelete
  23. Good day, everyone from Alex Porter's side, I am a customer technical support provider. Several people have contacted me, anxious that Can't Print from Quickbooks. Make sure that your printer is running the most current set of drivers as one of the simple remedies for the problem.

    ReplyDelete
  24. The number one online slots casino website, online baccarat.
    is the best online slots Ours will have slots, lottery, boxing, casino.
    Pokdeng online online slots web
    สล็อตเว็บตรง

    ReplyDelete
  25. สล็อต wallet
    just as before will get good information is here

    ReplyDelete
  26. สมัครสล็อตเว็บตรง

    If you have never bet on gambling games before and become a new gambler It is recommended to bet on online slots games because slots are the easiest gambling games. No complicated rules and no complicated formulas. even though I've never bet before can be easily understood

    ReplyDelete
  27. Good post and very informative. I am amazed how to jot down the information, good work. If you want to know how experts write assignments so efficiently, get in touch with SourceEssay based online assignment help team anytime.

    ReplyDelete
  28. Amazing article! You fellows at Assignmenthelped provide useful articles on a variety of subjects. A student studying in finance or in a field linked to finance may face a variety of difficulties. Our financial management assignment help professionals will make sure that your financial management assignment is completed on time and that it enhances your skills. Visit now :- Financial Management Assignment Help

    ReplyDelete
  29. Hi...
    The CUBE is a SQL Server Analysis Service (SSAS) or generically known as an online analytical processing (OLAP). Installing CQD – QoE CUBE.
    You are also read more Personal Loan online

    ReplyDelete
  30. page and would like you to keep updated on news. And upload current articles for us to read continuously For thorough tracking ทางเข้าเล่น pg slot

    ReplyDelete

  31. Fashion-forward designs such as those from Bella + Canvas prove the tank top can look great anywhere. blank apparel wholesale distributors

    ReplyDelete

  32. wholesale blank apparel, jackets, pants and tank tops to wholesale hats and totes we have full line blank apparel, hats and bags to fit all of your branding needs.

    ReplyDelete

  33. So try out our instant quote by adding blank hoodies, blank t-shirts cheap polo shirts and other blank apparel to your shopping cart than visit our decoration page and select your method of decoration, upload your artwork, blank apparel wholesale give us a few basic details and we will provide you with an instant quote for the decoration of your choice.

    ReplyDelete
  34. It’s interesting and knowledgeable ideas shared. I really appreciate you for the good work. Thank you for sharing. Visit here tasued admission list

    ReplyDelete
  35. howdy, your websites are really good. I appreciate your work. สล็อตออนไลน์ /โดโด้

    ReplyDelete

  36. slot joker
    สล็อตออนไลน์ ที่เป็นเกมออนไลน์ยอดฮิต อยู่ตอนนี้ และ พันธุ์ทิพย์ เป็นแหล่งข้อมูลที่ คนถามถึง เว็บสล็อต slotjoker นั้นมีสูตรลับสำหรับ เล่นสล็อตแตกบ่อย และ โดยปกติผู้ดูแลเว็บไซต์ จะลบมันออก ทำให้หาข้อมูลเกี่ยวกับ สล็อตค่ายไหนดี pantip ค่อนข้างยาก แต่ก็ไม่ได้ยากขนาดนั้น เราพร้อมแนะนำ ผู้เดิมพันเสมอ ผู้เดิมพันส่วนใหญ่ มักจะมองหาข้อมูล เกี่ยวกับสล็อตออนไลน์ เช่น ปั่นสล็อตค่ายไหนดี slotjoker-spd
    มั่นคง และ ปลอดภัย ซึ่งสล็อตนั้นดี โบนัสมักจะใช้ไม่ได้ หรือแคมป์สล็อตนั้นแตกง่าย สิ่งนี้สามารถเพิ่มโอกาส ในการได้รับรายได้ ผู้เล่นบ่อยขึ้น แต่อย่างไรก็ตาม จุดเด่นสล็อตออนไลน์ คือการออกโบนัสจำนวนมาก รางวัลใหญ่ถูกจับฉลาก โดยเฉพาะถ้าคุณรู้วิธีเล่นสล็อต

    ReplyDelete
  37. This comment has been removed by the author.

    ReplyDelete
  38. This comment has been removed by the author.

    ReplyDelete
  39. This comment has been removed by the author.

    ReplyDelete
  40. I happily found this website eventually. Informative and inoperative, Thanks for the post and effort! Please keep sharing more such blogs. If you facing QuickBooks Error 6143 then follow the below resources to rectifying the problem.

    QuickBooks error 6143 Blogs Resources: Blogspot

    QuickBooks error 6143 Blogs Resources: Medium

    QuickBooks error 6143 Blogs Resources: Atolinks

    QuickBooks error 6143 Blogs Resources: Onfeetnation

    QuickBooks error 6143 Blogs Resources: Writeupcafe

    ReplyDelete
  41. I happily found this website eventually. Informative and inoperative, Thanks for the post and effort! Please keep sharing more such blogs. If you facing QuickBooks Error 6143 then follow the below resources to rectifying the problem.

    Qbdbmgrn Not Running on This Computer Error

    ReplyDelete
  42. This comment has been removed by the author.

    ReplyDelete
  43. I would like to say that this blog really convinced me to do it! Thanks, very good post.สล็อตวอลเลท

    ReplyDelete
  44. You will be qualified to fly with your aide pets if there should arise an occurrence of any physical or mental problems or incapacities. The air transat pet cargo cost might rely upon the hour of buying the creature transport administration. Your flight objective is additionally considered while ascertaining this fee.

    ReplyDelete
  45. There is a wide range of software that you can install on your computer, but not many people know how to install QuickBooks desktop in Windows and Mac. This article will teach you the basics of installing QuickBooks desktop, which includes things like setting up a file sharing method between your PC and laptop. https://www.myonepro.com/

    ReplyDelete
  46. We know that time is of the essence when it comes to qqi assignments, so we offer fast turnaround times and excellent customer service. Our team of qqi assignment writers in Ireland are available 24/7 for any queries you might have about our services or your assigned task.

    ReplyDelete
  47. xoslot ทางเข้า จัดให้ และก็ พร้อมมอบให้กับลูกค้าทุกคนอีกทั้งใหม่ pg slot และก็เก่าสิทธิพิเศษที่คุ้ม โดยมีให้เลือกรับเครดิตฟรี แบบต่างๆ ล้นหลามเป็นต้นว่าสมัครเป็นสมาชิกฟรี

    ReplyDelete
  48. วิธีเข้าร่วม PG King789 ที่ชื่นชอบการเล่นเกมออนไลน์แล้วต้องการหาเว็บไซต์ที่มีเกมส์คาสิโนออนไลน์ที่เยอะและมีคุณภาพสูง ไม่ควรพลาดที่จะรู้จักกับเว็บไซต์ PGSLOT

    ReplyDelete