Dealing with SQL AlwaysOn in Skype for Business Server 2015/2019 Powershell Style

Dealing with a Skype for Business deployment with SQL AlwaysOn isn’t an easy task as there are a number of different elements involved from ensuring your databases are in the correct configuration to security permissions across the nodes.

I did originally create the following script while doing a customer deployment and have improved/modified to ensure I take out most of the headaches involved when deploying your backend databases.

The script runs through the following actions;

  • Check if SQL Instance
  • Check if Failover Clustering Role in configured on the two SQL servers
  • Ask to configure Failover Clustering Role (If required)
  • Convert and backup all Skype for Business Databases
  • Detect Skype for Business Folder on source SQL Server and copy to secondary
  • Configure SQL Server Service for AlwaysOn
    • Repeat task manually on the secondary server

Complete your AlwaysOn Configuration using the SQL Management Studio


Set-SfBSQLDatabases (980 downloads)

Change Log

Version 1.1 – Features

  • Support Skype for Business 2019
  • Support for SQL Server 2014 Enterprise, SQL Server 2016 Enterprise


Reporting Issues

If you identity any issues within running the script please email

The Author – Blogabout.Cloud

Leave a Reply

Your email address will not be published. Required fields are marked *