Update 2/19/15 - Added database versions for February 2015 Cumulative Update.Update 12/11/14 - Added database versions for December 2014 Cumulative Update.Update 11/20/14 - Added database versions for November 2014 Cumulative Update.Update 10/29/14 - Added database versions for October 2014 Cumulative Update.Update 9/23/14 - Added database versions for September 2014 Cumulative Update.Update 8/6/14 - Added database versions for August 2014 Cumulative Update.Update 4/7/14 - Added database versions for Persistent Chat compliance database.Update 1/8/14 - Added database versions for January 2014 Cumulative Update.Update 10/8/13 - Added database versions for October 2013 Cumulative Update.Update 7/2/13 - Added database versions for July 2013 Cumulative Update.
After downloading and installing Lync Server 2013 updates from KB2809243, it is important to remember to go back and apply the back end database updates. The steps to apply the back end database updates are listed in the KB article. After applying the back end database updates, you can use the Test-CsDatabase cmdlet to make sure that the databases are up-to-date.
The cmdlet will show you the expected version and the installed version, as well as whether or not the database is up-to-date:
The tables below list the back end database versions for RTM as well as each cumulative update:
Awesome info. Thanks for the post it has been most helpful.
very useful, thanks.
Thanks Doug, really helpful.
For Easy Reading of current version:
Test-CsDatabase -ConfiguredDatabases -SqlServerFqdn sql01.tomuc.int | Select-Object databasename,installedversion
Thanks for the update when each CU is published. Very nice :)
after update lync 2013 rtm to cu3, i see that xds installed version is 10.13.1.
1 vm deployment, Lync 2013 standard with sql express 2012
Make sure that you also ran Step 3 from KB2809243 to apply any updates to the CMS.
thx man, after
Install-CsDatabase -CentralManagementDatabase -SqlServerFqdn CMS.FQDN -SqlInstanceName DBInstanceName -Verbose
working fine and xds version is 10.13.2.
No need to even hardcode the SQL server in many environments. Test-CsDatabase -ConfiguredDatabases -SqlServerFqdn (Get-CSService -UserDatabase).PoolFqdn | Select-Object DatabaseName,Installed*,Expected*
After running the database updates Lync Mobile stopped working on iPhones.
Do you have the mgccomp database details for Installed Versions of the different Cumulative Updates?
@RussellYep. I just updated the post with information on mgccomp.
how about September 2014 security CU just released. i cannot seem to spot any difference in DB version although KB state to run database upgrade even for systems on August 2014 CU. thanks.