Skype for Business SQL Always On Database Script – Change Log

Hello Readers

This post is to track all changes made to the Skype for Business SQL AlwaysOn Script I have made available via the Technet Gallery.

 

Information about Script

I have been recently working with a lot of Skype for Business Deployments with SQL AlwaysOn BackEnd Servers and decided to make a little script which helps take some of the pain out the process. This script will Alter the SQL Databases into Full Recovery Mode, execute a SQL Backup and robocopy the database/log folder directories from the Primary SQL Server to the Secondary SQL Server. This will then allow you add the databases into the Availabilty Group with out performing any more manual steps to the Skype for Business databases and build process.

This script will alter and backup the following Skype for Business databases

  • cpsdyn
  • rgsconfig
  • rgsdyn
  • rtcab
  • rtcshared
  • rtcxds
  • xds
  • lis
  • LcsCDR
  • QoEMetrics
  • LcsLog

Then copy the folder directories for the Database and Log files to the Secondary SQL Server.

How do I use this Backup-SQLDatabaseSFB.ps1 script?

Head over to http://blogabout.cloud/skype-for-business-2015/sql-alwayson-script

 

Download Script

https://gallery.technet.microsoft.com/Alter-Your-Skype-for-4d3d91f9

image

Version Changes

: 0.1 Initial Script Build

Initial Build of the Skype for Business SQL Always On Script

: 0.2 Minor Script Changes (Added SQL Database Check and Skip if not present)

In this build we see that the script has been modified to “Check and Skip” if a Skype for Business Database is not available for example Archiving or Monitoring Databases.

: 0.3 Added Robocopy for Database/Log Information

In this build we see that the script has been modified to Robocopy the Folder Structure of Database and Log directories to the secondary SQL node.

: 1.0 Ready for General Release

Build released to general public

: 1.1 Remove Persistent Chat Databases (Not Supported for AlwaysOn)

In this build we see that the script has been modified not to include the MGC and MGCCOMP Databases

: 1.2 Robocopy points to the CsData Directory where the Skype for Business Databases are held

In this build we see that the script has been modified to so Robocopy points to the CsData Folder where all SQL Databases are held.

: 1.3 Additional Node Support

In this build we see that the script has been modified to support multiple SQL Nodes within the AlwaysOn Availability Group

: 1.4 Administrator Check

In this build we see that the script will check for evalvated Administrator privilages.

: 1.5 Minor Updates

In this build, minor script updates have been applied

: 1.6 Minor Updates

In this build, minor script updates have been applied

Download:

Technet Gallery

Github

1 thought on “Skype for Business SQL Always On Database Script – Change Log”

Leave a Reply

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