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.


  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?


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

  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?



  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?

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

  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"

  6. This website can live streaming , you can join at my site :
    agen judi online terpercaya
    Prediksi Bola

    Thank you

  7. It is important for medical science research paper service students to seek Medical Science Assignment Help from a reputable custom medical science writing company so as to be assured of good grades in their medical science essay writing services.

  8. Law assignment writing services are essential for law essay writing services and Law Research Writing Services seekers.

  9. printers are exceptionally favored by individuals for both home and business purposes.In general,these printers and scanners accessible in the market, best case scenario costs range.Most individuals incline toward for getting best printing solution.Now it tends to be used for periodic family unit use to customary every day imprinting in the office.if you have any issue or need with www hp com setup.we understand your issue and question.

  10. ห้ามพลาดครีม มาร์คสิว ในตำนาน>> REVIEW
    ตามซีรี่-หนังดัง>> REVIEW ตามซีรี่-หนังดัง

  11. Maybe the best site right now Terrible that no one is watching

  12. We are proud to say that all our products buy clonazepam powder online are not displayed online without going through an intensive quality assurance process. buy ativan (lorazepam) online They are high-quality and unmatched in the industry. buy peruvian cocaine online, If you’re not happy, talk to us. buy volkswagen cocaine online Your happiness and satisfaction is our priority. buy crack cocaine online , buy cocaine powder online , buy mescaline online

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

  14. Do you want to buy Volkswagen cocaine online? If yes then you have come to the right place. At ketamine online USA you will get all the products of your choice and that too at a reasonable price.

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

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

  17. Scholars need to connect with effective online assignment writing for do my assignment query. For that, visit website of online service providers and check their reliability before placing your order for any subject.

  18. Our essay writers service accepts orders that have an urgent requirement. No matter how close your deadline is, you can surely trust our essay writers online with your papers. The eleventh-hour papers are accepted by our essay writers Australia, US, and the UK who work on these essay assignments on top priority. Our goal is to deliver top-quality work to all our clients at the most affordable price. We surely arrange for you a writer who’s the best so that you get the best chance to improve your grades!
    Reference From -
    Related Pages-
    Free Online Academic Tools
    Think Global Act Global
    paper writing service

  19. Canon.Com ijsetup will manual you to Install Canon printer brand new updated drivers, for Canon printer setup you could additionally visit.NBC application is available for a huge range of devices that include TVs, streaming media players, gaming consoles, Blu-ray players, and more. You can watch NBC on all these devices if they have updated software. To watch this you need to enter the device’s activation code at and that’s it. In this article, we will discover the installation and activation process for NBC.espn known for providing entertainment and sports channels to its audience and it serves the best available content. You can also watch the live streaming channels with espn.cpm/activate anytime anywhere.In this article, you will get the easiest way to activate your Capital One card online by visiting the official capital one credit card activation online portal at and When you apply for your WALMART Capitalone credit or debit card, after the completion of process of card you’ll receive the card via post. But that card will not be ready for use. to use this card you first have to activate the card.

  20. How to activate TNT Drama on your device via Drama allows the users to watch their favorite TV channel shows on one platform.Students, faculty and staff have access to a microsoft office downloadfor free for personal use on your computer, smartphone or tablet.Once, you will finish your ProtonMail account setup then you can use your protonmail log in credentials to start sending and receiving emails over the ProtonMail app/website. So, with no further delay let’s head to the steps to create a new account for ProtonMail Login. "covid-19"If you have recently installed the latest [Epson Printer Drivers Update via Apple's Software Update tool or from the Apple Corp. website, then you may need to refresh your Epson printer driver installation. The latest printer driver update provides updated driver software to many Epson printer models.All the printers require a proper driver installation. Some users due to lack of knowledge of technicalities don't know how to Download brother printer drivers.

  21. Activate your HGTV GO channel at the page for different streaming devices by following the information provided in this guide.PayPal is an efficient service, as long as you always make sure to have a cushion of money in your account. Not having enough cash in your balance can lead to late payments or prevent you from making quick transactions to other accounts.Click Download or Get to install it.Open the channel.Copy the activation code displayed.Go to the activation code.Select your TV provider.Log in with your TV provider.Open Google Play Store in your smart TV. Install the Bravo TV program. Open the Bravo TV program. Copy the activation code. Go to web browser and enter the activation code. You are ready to start streaming.You realize that on you can watch your number one program? The principal thing you need to visit the web initiation page utilizing internet browser. At that point you should experience the Activation cycle with your TV makers’ membership appeared on the screen. When the arrangement has succeeded, the PC or any gadget would now be able to be streamed on the web.

  22. on roku – 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 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, then keep reading on to learn more!To activate ESET software follow the provided steps.You first need to go to 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.

  23. Go to any other device such as mobile phone, tablet or desktop. From the web browser, enter the six-digit xfinity stream authorized code provided to the Roku device.Find Etrade Log In Results Quickly On Discover Info On Finance Companiwa. Search multiple engines for etrade login.You will need to use the etrade login page to access your stock trading portfolio account online when you are ready to buy or sell stocks at​ ...Get your office setup from If your version of Ms Office setup came with your PC, you can download or order a latest version from office setup You can also set up an office with a 25-digit activation code.

  24. Once you successfully purchase Ms. Office Equipment, you will get an ,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 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 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 and activate with the help of Amazon's activation code.

  25. and be able to troubleshoot your issue.You can pay your credit card or your bills through the Xfinity My Account app and customize your device issue, WiFi network name and password by visiting .To get help for any kind of problem, you can use this you successfully purchase Ms. Office Equipment, you will get an which you must enter the key. Download and install MS 365 in your PC with the help of the website given by us and provide the best for your office. To install the ,click on the link given by us.Canon ijsetup CD is not the well-suited to use setup installation for longer.The Canon printer enhances scan functionality, and includes a robust security feature set. Using a Canon printer service phone, you can get a full installation of the canon printer drivers
    and go to the installed Canon printer to download the canon printer setup.

  26. Once the device is found, you can add roku paid channel or roku channel from with activation code store. Connected to your TV screen to your TurboTax CD/Download account. Access your order history and TurboTax desktop software downloads, unlocks, and tax documents.Have you also received an American Express card and looking for a way to confirm it? So keep going through this article as we are going to discuss all possible ways to confirm an American Express card. But before moving on to steps make sure to collect some necessary information that you require while confirming your american express/confirmcard.Webroot Antivirus is the fastest and easiest software to download, install and In addition, it automatically updates without slowing down your system. Because of which you always get the most protection. So we recommend you to download Webroot Antivirus. Webroot Antivirus detects online threats and blocks them quickly.

  27. Shop your local Walmart store online anytime, anywhere. You can even use the Walmart online shopping app and start shopping now. Then, choose a convenient pickup or delivery time. We'll do the shopping and experts will pick the best quality items, or your money back.For more information, visit walmart online shopping our website.The actions recorded can vary from mouse tracking to what documents or programs are open and closed to launching programs.tinytaskdevice is helpful to users who want to automate their repetitive tasks and want to easily access them right away rather than performing repeated actionsoffice it the pile of office gadgets to make your working smooth and effective.visit: to downloaded in your PC with the smart help.Endeavor which is amazingly easy to present, download and recoup.Usage of it is moreover fundamental and the customer can pick up capability with the use of it adequately. Online Support&help elective is in like manner open in all application which gives a minute guideline.Microsoft Office is an application is used in most of the businesses and organizations Install office setup on your Pc's to get best advantage of it. mostly used tasks are ms-word, Ms-excel and Ms-powerpoint.

  28. The need for a reliable antivirus like Norton Enrollment is increasing, you can download it by visiting the website only companies as a measure of data security, but everyone is now relying on antivirus programs that can be found on the
    with product key page. If you have any problem you can visit our website 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 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 website.


  29. Here is the link you need to visit: office it the store of office gadgets to make your working smooth and effective.visit: www. to downloaded in your PC with the savvy help. office setup is the best programming which is broadly utilized in globe . It is a shocking association that causes you release your best contemplations, complete things, and stay related on the go. for more subtleties visit: today. office it the heap of office mechanical assemblies to make your working smooth and effective.Get it downloaded in your PC with the speedy assistance visit here for more nuances. Try which is incredibly simple to exhibit, download and recover. Use of it is in addition principal and the client can get capacity with the utilization of it enough. Online Support&help elective is in like way open in all application which gives a moment rule. office it the heap of office devices to make your working smooth and effective.visit: setup to downloaded in your PC with the savvy help.

  30. Norton Security Premium gives all what Norton Security does, in addition to it backs up the individual records, photographs, recordings and different recollections on your PC.Norton Security gives you the best of Norton for the numerous ways you interface. With a solitary basic setup, you get complete insurance that is made to verify your preferred gadgets—PCs, Macs®, cell phones and tablets—so you can be sheltered in any case and any place you associate. Norton security software is used broadly and it provides tha simplest ways to useand it is the most effective protection for yur pc's and computers. Install it in your PC's and stay free from viruses.Do visit for more details. All you have to do is to activate your Amazon Prime Video on using the activation code you retrieve Payment Products. Amazon Rewards Visa Signature Cards; Store Card; Amazon Business Card; Amazon Business Line of Credit; Shop with Points;


  31. Webroot safe is one of the best antivirus software which provides security from malware and threats. offers full security for your personal information and banking details is the cheapest antivirus software. Webroot product key is an alpha-numeric code of 20 digits, that can help users to trigger their webroot antivirus program.Get protection after downloading, installing and activating with key code through if you buy the product online then you will receive the Keycode on your registered email i'd that you have provided during purchase.Click to open Webroot safe Console. Webroot AntiVirus keeps watch on obscure projects until its cerebrum in the cloud goes to a judgment. The small nearby program clears out the assailant and turns around its activities. It's an exceptionally unordinary framework, however testing demonstrates that it carries out the responsibility, and does it well.

  32. If your computer does not have the CD-ROM drive or you do not have the Setup CD, follow the steps given below. Visit Click Set Up. Either type in the model name of your printer, or click the first two letters shown under First Letters.Canon printer that can be downloaded via Canon Printer Setup page is the best wireless printer that you can connect to your device and print data smoothly. Canon ijsetup CD is not the well-suited technique to use Canon IJ Scan Utility Windows 10 setup installation for longer. One can also install from anther origin if your device is having issues in the online installation or any other. Roku gives the least complex approach to stream excitement to your TV. Roku Account With a large number of accessible channels visit here for more subtleties.Roku provides the simplest way to stream entertainment to your TV. With thousands of available channels visit here for more details. Roku is a streaming device that helps you watch thousands of paid & free video content on your TV screen via . Download the setup from and enter roku activation code.

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

  34. AVG Antivirus can be installed fairly easily and can be installed by visiting It facilitates the custom scanning method used by the system, along with real-time security. Avg is a well- known name in the field of virus protection. The reason for which this name is common among all end users is its free antivirus and malware protection.It not only sounds free but it provides a lot more with no money. It scans for virus and malware. AVG is a known name among the users for providing the best security features against any malware. It provides online security, web security, offline security, family security and many other features to its users. For AVG Activate, Download & complete installation online to get rid of harmful viruses.

    Disney, one among the popular channel is now available on your streaming media players. The channel provides you access to Disney shows like Jessie, Phineas, Maddie, Austin and a few more at Disney Now is compatible with multiple devices including Android, iOS, Kindle, Roku, and Apple TV. You can also watch online using a supported web browser like Chrome, Firefox, or Brave. - Disney Now has got some great popular shows on it which makes it one of the most trending streaming networks nowadays.

  35. Here’s How to Use with your Disney+ Account Disney Plus is one of the most popular streaming services in the world right now. 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.  offers a collection of world favorite movies, if you visit the Disney Plus Begin website you will see top movie favorites. Disney has global distribution agreements with apple google Microsoft, Roku, Sony, Amazon, Samsung, and LG Having distribution agreements with these popular manufacturers of mobile media devices and smart TV's allows users to connect with in a variety of way.

  36. Xfinity is a platform which will keep you entertained and offers HD content at a very exciting price. Here you can stream any content online.Xfinity. Let's activate your device. Enter your activation code: Access on Roku and smart TV's will be available once your Xfinity products have been set up in your home. Go to to sign in or create an account, and then enter your activation code (even if you've already started your taxes for tax year 2020, you'll still need to activate the code). Select Continue and then select your state. Steps to be followed: · Open the web browser on your lp or Desktop. Visit for the official website of AmericanExpress/CreditCard or click on the official website.Shop your local Walmart store online anytime, anywhere. You can even use the Walmart online shopping app and start shopping now. Then, choose a convenient pickup or delivery time. We'll do the shopping and experts will pick the best quality items, or your money back.

  37. TinyTask is a utility software created by Vista Software. It's incredibly helpful, and what's better is that it's completely free! tinytask It allows users quick and easy access to automating playback and recording. Prior to investing in a managed portfolio, Etrade login E*TRADE Capital Management will obtain important information about your financial situation and risk tolerances and provide you with a detailed investment proposal, Etrade login investment advisory agreement, and wrap fee programs brochure. Epson Printer Drivers is the link between your Computer and the award-winning Epson Printers. It enables your Computer to command and control these robust printing machines. To download Brother printer drivers, you can download it at the official brother printer site that is Brother Printer Drivers visit here.