Wednesday, August 22, 2012

Adding a SQL Mirror to an Existing Lync Server 2013 Back-End

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

Lync Server 2013 now supports SQL mirroring (synchronous) for back-end databases.  In fact, this is the preferred/supported configuration.  This post will describe how to add a SQL mirror database to an existing pool’s back-end SQL instance.  This post is not meant to show SQL specific configurations. 

Here are a few prerequisites, requirements, and notes:

  • All SQL servers including the mirror must be at the same SQL version
  • The two SQL mirror nodes must use the same Edition, the mirror can be different
  • Use a witness server if you want to achieve automatic failover of the SQL database between the mirror
  • You must deploy the witness at the same time as the mirror is set up within the Lync topology
  • The database instance that will be used as the mirror should have the same LUN/file path configuration as the primary database
  • The SQL mirror does not need to be configured beforehand, publishing the Lync topology will configure and enable mirroring
  • The SQL servers and witness must be members of the same domain

In my example, I am going to deploy the SQL mirror without a witness server due to lab constraints.  This post also assumes that you have a second SQL instance already configured to host the mirrored databases.

If you are adding the SQL mirror after deploying your primary database, make sure that the mirroring port is configured on the SQL instance in the topology.  You can see this setting by navigating to Site –> Shared Components –> SQL Server Stores

Lync 2013 - SQL Mir - 2 primary port define

First step is to edit the topology.  Navigate to the Enterprise Front-End pool and select Edit Properties…

Lync 2013 - SQL Mir - Edit Pool

Check the option to Enable SQL Server store mirroring, then click the New… button:

Lync 2013 - SQL Mir - Edit Pool - assoc - markup

Next define SQL server store for the mirror:

Lync 2013 - SQL Mir - define sql

Click OK and then publish your topology.  You will be prompted to configure a File Share on the Create Mirror Databases dialog:

Lync 2013 - SQL Mir - publish

Click on the “File Share is required” error and click Settings… button and define a files share:

Lync 2013 - SQL Mir - publish - sql file share2

Remember, for your file share to make sure the proper permissions are set up so that both SQL servers have access to the share.  Thanks to Doug Deitterick’s Blog for that help.

Lync 2013 - SQL Mir - file share perms

Finish the Publishing Wizard, make sure everything is a “Success”. 

Lync 2013 - SQL Mir - publish - success

Also, check the “To-Do List” link. It says I need to restart my Lync services on the FE Pool servers.  This can easily be done by running:

Get-CsWindowsService | Stop-CsWindowsService

Get-CsWindowsService | Start-CsWindowsService

Lync 2013 - SQL Mir - restart services

Checking the SQL Mirror Node, we can see the Lync databases:

Lync 2013 - SQL Mir - mirror node check

You can also added your Monitoring and Archiving databases to the SQL mirror by editing the topology and adding the already defined mirror on those databases:

Lync 2013 - SQL Mir - Edit Pool - ArchMon

This post described how to add SQL mirroring to your Lync Server 2013 back-end.

70 comments:

  1. Hi Tim, a couple of questions.

    re: "The database instance that will be used as the mirror should have the same LUN/file path configuration as the primary database".

    I am confused by this. Are you saying the the SQL instance used for the mirror needs to be on the same file path as the SQL instance I use for the mirror?

    re: The File Path.

    Why is there a file share needed? Isn't the mirror all done in SQL (i.e. SQL db mirroring)?

    Maybe I am not understanding the SQL mirroring functionality. Does the primary write to disk (the file share) before sending it to another SQL instance to be mirrored?

    Thanks

    ReplyDelete
  2. Apologies...in that first question I meant "...the same SQL instance used as the PRIMARY (not the mirror)"

    ReplyDelete
  3. Hi Tim,

    The file share that the mirroring initially uses, after is has set up the mirror does it ever use this again i.e. is the file share used in-line once the mirror is set-up? I am just wondering if it should be set-up using DFS or another HA model?

    Regards,

    Dave

    ReplyDelete
  4. In SQL Server 2012 SQL Mirroring has been depreciated and will not be supported in future versions of SQL Server. Since AlwaysOn Availability Groups (SQL Server 2012)is now recommended has anyone deployed Lync 2013 with AAG's?

    ReplyDelete
    Replies
    1. Yes. AAG works great. I have tested it in the Lab. No user impact during failover.

      Delete
  5. Can i use the same Witness server for multiple BE pair. As per Technet yes but when you actually try to add the same from topology builder it gives error " Server is already in use in this topology"

    So in my pool1 i have mirroring with withness (Witness server xyz)
    I am trying to setup mirroring with withness for pool2 and in toplogy if i try to use the server XYZ as witness server it gives me error "same server is in use in published topology"

    ReplyDelete
  6. Maybe the best site right now Terrible that no one is watching
    myoceanhousecondo
    ecurie-competition

    ReplyDelete
  7. In year 2020, How to Create a website without knowing anything about web disigning and web development or any type of codings. Whether you want to create a website for your company business or for your own you can create it by doing right things. These 5 easy steps for beginners will help you to create a website without spending your money.
    How to create a website

    ReplyDelete
  8. Saved ass a favorite, I really like yor web site!

    ReplyDelete
  9. tbs.com/activate on roku – Tbs.com Activate Roku Player · Firstly, you need to explore to the Roku channel store and look through the rundown of stations under ...
    How do I get my Download IJ Scan Utility Windows 10 Scanner Software? Download IJ scanning utility windows 10is an application that allows you to scan photos, documents, etc easily. You can complete from scanning to saving at one time by simply clicking the corresponding icon in the IJ Scan Utility main screen.Sign in to your espn account. A espn account gives you access to an amazing selection of movies, TV shows, music and more from the espn.com/activateChannel Store.f you want to watch all your favorite NBC shows on multiple devices around the house and want to learn how to use the nbc.com/activatecode, then keep reading on to learn more!To activate ESET software follow the provided steps.You first need to go to eset.com/us/activate.Put in your ESET activation key.Choose the correct country.Enter your first and last name.Provide the enterprise’s name if you want.Provide the email address.

    ReplyDelete
  10. Once you successfully purchase Ms. Office Equipment, you will get an office.com/setup ,in which you must enter the key.Mcafee antivirus acts as a shield of the device. It protects against viruses, malware, online threats etc. You can download, install and activate mcafee.com/activate with activation code.mcafee antivirus provides protection from viruses, hackers, spyware and more harmful websites. If you want to protect your devices against harmful data, download mcafee antivirus by visiting the mcafee.com/activate website.The Amazon My TV Code program requires the customer to have an Amazon account and a streaming device or TV. Amazon Prime Video is available on almost all streaming devices like Roku, Amazon Fire TV, Chromecast. All you have to do is go to amazon.com/mytv and activate amazon.com/mytv with the help of Amazon's activation code.

    ReplyDelete
  11. The need for a reliable antivirus like Norton Enrollment is increasing, you can download it by visiting the website Norton.com/setup.Not only companies as a measure of data security, but everyone is now relying on antivirus programs that can be found on the www.norton.com/setup
    with product key page. If you have any problem you can visit our website Norton.com/setup and get help.Mcafee antivirus acts as a shield of the device. It protects against viruses, malware, online threats etc. You can download, install and activate Mcafee.com/activate with activation code. mcafee antivirus provides protection from viruses, hackers, spyware and more harmful websites. If you want to protect your devices against harmful data, download mcafee antivirus by visiting the Mcafee.com/activate website.

    ReplyDelete
  12. Hulu Plus on your gadget, either utilize the on-screen console to enter your Hulu sign in data or go tohulu.com/activate and enter the gadget initiation code. Both of these strategies will enable you to utilize Hulu on any Hulu-upheld gadget. www.hulu.com/activate To activate Hulu Plus on your gadget, either utilize the on-screen console to enter your Hulu sign in data or go to hulu.com/activate and enter the gadget initiation code. Both of these strategies will enable you to utilize Hulu on any Hulu-upheld gadget. hulu.com/activate Would you like to set up hulu antivirus in your PC?... at that point click here for more subtleties.

    ReplyDelete
  13. Here’s How to Use DisneyPlus.com/Begin with your Disney+ Account Disney Plus is one of the most popular streaming services in the world right now. DisneyPlus.com/Begin With the entire catalogue of Disney classics available, plus new favorites like Hamilton and exclusives like Muppets Now, it’s not hard to see why. DisneyPlus.com/Begin  offers a collection of world favorite movies, if you DisneyPlus.com/Begin visit the Disney Plus Begin website you will see top movie favorites. Disney has global distribution agreements with apple google Microsoft, Roku, Sony, DisneyPlus.com/Begin Amazon, Samsung, and LG Having distribution agreements with these popular manufacturers of mobile media devices and smart TV's allows users to connect with DisneyPlus.com/Begin in a variety of way.

    ReplyDelete
  14. I want to start a blog to write about everything that happens at school and
    with friends…anonymously…any sugestions?.

    Try to check my blog: 풀싸롱


    ReplyDelete

  15. A person necessarily assist to make seriously articles I’d state.
    That is the first time I frequented your web page and thus far?

    my web page; 안마
    (jk)

    ReplyDelete
  16. This is a simplest source to connect printer with devices like windows, Mac or iPhone. You can download printer driver and software of Canon Printer for your device through this link
    Check how to install brother printing using USB connection on windows 10 computer from Support.brother.com/windows , the features are also available !!
    Do you want to know, how to install norton with product key? I am sure you do! Check the link to norton.com/setup explore the complete setup guide for norton!
    Here is the simplest way to reach microsoft, check out the link help.microsoft.com talk to a person to see the contact details, the chat process and the purpose to talk to a microsoft person.

    123.hp.com/setup print scan  is a official URL which helps you to install & download HP printer drivers for Windows 10. 
    Read this article www.miscrosoft365.com/setup carefully, if you want to install microsoft 365 on your computer, also check the features and procedure for how to use it.

    ReplyDelete
  17. Case Study Homework Help

    Best Assignment Experts has been providing Case Study Homework Help to students to upgrade their grades. We have a vast knowledge of subject matter experts and scholars who have so much knowledge. We assure to pen down customized, 100 % plagiarism-free and well-written assignments at a very affordable price. We are 24*7 accessible.

    Contact Us: +65-91753078

    ReplyDelete
  18. FantasyDangal has become one of the most popular fantasy cricket app. In a very short time, the FantasyDangal app has gained a lot of popularity. The app is available in nine languages and offers a range of bonuses and offers to users who want to play fantasy cricket, win cash, and stay in the game. The app also offers different modes such as Safe Play and Regular play that make it easy for users.
    Also read: Most dangerous batsman in IPL | Most dangerous team in IPL

    ReplyDelete
  19. That Is Very Interesting, You Are An Excessively Skilled Blogger. Stay In Control Of Your Online Trades With AximTrade Review Login, A Cloud-based Online Trading Platform.

    ReplyDelete
  20. In this article let us explore those rarest zodiac sign :- Aquarius (January 20 – February 18). The sun enters Aquarius at the end of the month.

    ReplyDelete
  21. At Web Tech Experts, we have done a lot of research on Search engine optimization for Digital Marketing For Forex Broker . We have tried to present it in the most simple and understandable way.

    ReplyDelete
  22. Tradingzy Is The Best And Most Reliable Seo Company And Offers A Wide Variety Of Forex Trading Seo Packages , Including An Affordable Monthly Subscription Service, One-time Links, And Blog Comments. With Any Of These Services, You Can Be Assured That Your Site Will Rank Higher In The Search Engine Results Page And Receive An Influx Of Targeted Traffic.

    ReplyDelete
  23. Tradingzy Is The Best And Most Reliable Seo Company And Offers A Wide Variety Of Best Seo Company For Forex , Including An Affordable Monthly Subscription Service, One-time Links, And Blog Comments. With Any Of These Services, You Can Be Assured That Your Site Will Rank Higher In The Search Engine Results Page And Receive An Influx Of Targeted Traffic.

    ReplyDelete
  24. Online Stock Broker is an informational guide to help you find the right online trader in order to maximize your trading experience. Our search results are sorted by price, regulation and client score. We ensure that all services displayed on Online Stock Broker are highly rated and fully regulated.

    ReplyDelete
  25. Fetching excellent grades and Time bound deliveries have been the hallmark of Assignment Help UAE at GreatAssignmentHelper.com. Our experts are also known for prompt support and two-way communication with understudies while offering Online Assignment Help round the clock. Sign in to our bespoke Assignment Help services at the below link right away.Fetching excellent grades and Time bound deliveries have been the hallmark of Assignment Help UAE at GreatAssignmentHelper.com. Our experts are also known for prompt support and two-way communication with understudies while offering Online Assignment Help round the clock. Sign in to our bespoke Assignment Help services at the below link right away.

    ReplyDelete
  26. Get Real Time Harris Teeter Ess Market Overview, Displaying Live Data And Information On Demand. This Data Will Give You The Latest Updates On All Harris Teeter Ess As Well As Vital Information That You Need To Know Prior To Investing Or Trading.

    ReplyDelete
  27. You'll understand the market a whole lot better with the data and graphic tools provided by our stock quote system. You'll understand how certain economic events can affect your investments, and be able to answer questions from stock market friends concerning when to buy or sell Sos Stocktwits . You will have access to live charts, and you can receive instant notifications as stocks change in cost.

    ReplyDelete
  28. Are you looking to make money by trading currencies on the forex market? Do you want to find the best forex brokers with the lowest costs and fees? Our free guide provides all the information you need to start trading, selecting a reputable and safe broker, and understanding your Forex Trading Cost .

    ReplyDelete
  29. Our stock alerts provide you with the latest Truff Stock market trends so that you can stay up-to-date on all of the latest Truff Stock market moves.

    ReplyDelete
  30. Truff Stock Get free stock market quotes, stock information, company news, historical charts and financial overviews from Truff Stock . We bring you all the latest Truff Stock market & financial news All in one place.

    ReplyDelete
  31. Track your stocks in all major markets instantly with our unique live stock overview. See Bfarf stock live prices changes as they occur and view change details, including volume and share changes.

    ReplyDelete
  32. The most comprehensive guide to Forex Brokers and How To Start Forex Broker , showing you what you can save or earn by choosing the best broker for your needs – from Highest to Lowest Charges. Useful for both beginner and seasoned trader.

    ReplyDelete
  33. Dbd Forums Real-Time Overview Of A Stock, Including Recent And Historical Price Charts, News, Events, Analyst Rating Changes And Other Key Stock Information.

    ReplyDelete
  34. Stay on top of the market with our Live, Real-Time Stock Market overview. Get real time Ati testing login quotes and interactive charts.

    ReplyDelete
  35. As a new forex trader you need to know what the best brokers offers and their Start Forex Brokerage before you begin trading and investing, Use this guide to learn about trading costs, leverage and leverage limits, spreads and execution times, custodial services and market maker spreads .

    ReplyDelete
  36. Vo Colorstreet Com Login Is An Online Account, Account Opening And Order Management System Offered By The Vo Colorstreet Com Login

    ReplyDelete
  37. White Label Forex Meaning is an effective and affordable way to learn from existing expert traders, so you can use their techniques to start trading profitably for yourself.

    ReplyDelete
  38. At Tradingzy, we can help you learn what is forex seo and how to use it. We're a digital marketing agency focusing on SEO for the Forex Brokerage company. We're familiar with Google's updates and how to work with them effectively.

    ReplyDelete
  39. At Tradingzy, we’re digital marketing specialists. We focus on search engine optimization for the forex market. We’ve got the best ranking on Google for keywords like “ What Is Liquidity In Cryptocurrency .”

    ReplyDelete
  40. If you have been looking for facts about What Is Liquidity In Cryptocurrency and how it works, Then tradingzy is the best and most reliable place. because tradingzy is Digital Marketing agency focusing on Forex Seo.

    ReplyDelete
  41. "Forex Seo Services will help you increase your business by reaching the maximum number of potential customers through social media, Search Engines and direct advertisement.

    ReplyDelete
  42. If you want help regarding the Business Law Case Study then you can get the best assistance from us. We have a team of experts having a years of experience in the same filed. Feel free to contact us regarding any kind of assignment help.

    ReplyDelete
  43. Best Regulated Forex Brokers In Samoa Get Information On The Best Regulated Forex Brokers In Samoa . Read Reviews, Compare The Best Regulated Trading Platforms, & Find The Right Broker For You.

    ReplyDelete
  44. CMC Markets Review Is An Online Investment Platform That Makes It Easy To Trade In Cryptocurrency, Forex And Cfds. Our Platform Is Secure, Reliable, And It Ensures High Quality Of Service. Read More Here.

    ReplyDelete
  45. In search of the Best MT4 Forex Brokers In UAE ? The list we provide here is not exhaustive. We have chosen 5 of the best Forex brokers available in UAE so you can compare them side by side.

    ReplyDelete
  46. Wow, this is very valuable information, thanks for giving this information and also thanks for "Students assignment help" they also provide such type of helpful service for all UK students. if you are a student and you want assignment help then don't go anywhere just visit the site and get the best Assignment writing help uk.

    ReplyDelete
  47. Next time when you search for any query like do my assignment for me I would suggest you go for something cheap and fast.

    ReplyDelete
  48. Nice to read such informative posts. When I could not cope with my columbia supplemental essays examples I asked for online writing support. So I can now recommend a wonderful website with various features to get in a very short time.

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

    ReplyDelete
  50. pg slot ฟรี เครดิต แค่สมัครสมาชิกวันนี้รับทันทีเครดิต100% ฝากถอนง่ายๆไม่กี่ขั้นตอนกับเกมสล็อตออนไลน์คุณภาพอย่างค่าย PG SLOT ที่เว็บ PG-SLOT.GAME ของเรามอบให้ลูกค้าทุกท่าน

    ReplyDelete
  51. PG 789 Game เป็นเกมสล็อตออนไลน์ที่มีความนิยมอย่างกว้างขวางในวงการพนันออนไลน์ โดยเกมนี้มีการออกแบบตัวเกมให้สวยงามและมีระบบเสียงที่ดี นอกจากนี้เกม PG

    ReplyDelete
  52. Adding SQL mirroring to an existing Lync environment enhances data redundancy and fault tolerance. Why No Support This critical step bolsters system resilience, ensuring continuity in case.

    ReplyDelete
  53. Job seekers in Ireland need every advantage they can get, and a professionally written CV is a crucial asset. Our Cheap CV Writing Services Ireland combines affordability with excellence. Our team of experienced writers will transform your CV into a powerful tool that opens doors to new opportunities. Don't miss out on your dream job; choose us for budget-friendly, quality CV writing services.

    ReplyDelete
  54. Students can benefit from personalized lessons, interactive activities, and feedback, making it an ideal choice for individuals seeking to improve their English language skills, whether for academic, professional, or personal reasons. Online English tuition offers flexibility, accessibility, and the opportunity to learn at your own pace, making it a popular choice for learners worldwide.

    ReplyDelete
  55. Ultimately, understanding and budgeting for CFA course fees is an integral part of planning your journey towards becoming a Chartered Financial Analyst. By evaluating these costs alongside your career goals and aspirations, you can make an informed decision about whether pursuing this esteemed designation is right for you.

    ReplyDelete
  56. I visited the blog post you shared, and I found it informative on adding SQL Mirror to an existing Lync setup. One thing that caught my attention was the mention of "Assignment Help" from Do My Assignment, which could be a valuable resource for those managing complex IT setups like Lync. Thanks for the insights!

    ReplyDelete
  57. Thanks for sharing this insightful post! Your knowledge and writing style are impressive. For students struggling with their coursework, don't forget to explore the Do My Assignment Online services; they can be a real lifesaver.




    ReplyDelete