This post is to track all changes made to the Skype for Business SQL AlwaysOn Script I have made available via the Technet Gallery.
Chapter 1. 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
Then copy the folder directories for the Database and Log files to the Secondary SQL Server.
Section 2. How do I use this Backup-SQLDatabaseSFB.ps1 script?
Head over to http://lyncme.co.uk/skype-for-business-2015/sql-alwayson-script
Chapter 2. Version Changes
Section 1. : 0.1 Initial Script Build
Initial Build of the Skype for Business SQL Always On Script
Section 2. : 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.
Section 3. : 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.
Section 4. : 1.0 Ready for General Release
Build released to general public
Section 5. : 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
Section 6. : 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.
Section 7. : 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