Doug Deitterick's Blog

Information about Microsoft Lync, OCS, and Exchange UM.

How to Verify if Lync Server 2013 Database Updates Completed Successfully

How to Verify if Lync Server 2013 Database Updates Completed Successfully

  • Comments 16
  • Likes

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: 

Cumulative Update Back End Databases
  rtcxds  rtcshared  rtcab rgsconfig   rgsdyn  cpsdyn  LcsLog LcsCDR   QoEMetrics  xds lis
RTM 15.13.1 5.0.1 62.42.0 5.5.1 2.2.1 1.1.1 24.40.0 39.82.0 62.90.0 10.13.1 3.1.1
February 2013  15.13.1 5.0.1 62.42.1 5.5.1 2.2.1 1.1.2 24.40.0 39.82.1 62.90.1 10.13.2 3.1.1
July 2013 15.13.1 5.0.1 62.42.2 5.5.1 2.2.1 1.1.2 24.40.0 39.82.2 62.90.1 10.13.2 3.1.1
October 2013 15.13.1 5.0.1 62.42.2 5.5.1 2.2.1 1.1.2 24.40.0 39.82.2 62.90.1 10.13.2 3.1.1
January 2014 15.13.1 5.0.1 62.42.2 5.5.1 2.2.1 1.1.2 24.40.0 39.82.2 62.90.1 10.13.2 3.1.1
August 2014 15.13.1 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.2 62.90.1 10.13.2 3.1.1
September 2014 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.2 62.90.1 10.13.2 3.1.1

 

Cumulative
Update
Back End Databases
mgc mgccomp
RTM 1.42.0 1.7.0
February 2013 1.42.0 1.7.0
July 2013 1.42.1 1.7.0
October 2013 1.42.1 1.7.0
January 2014 1.42.1 1.7.0
August 2014 1.42.2 1.7.0
September 2014 1.42.2 1.7.0
Comments
  • 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 :)

  • hello,

    after update lync 2013 rtm to cu3, i see that xds installed version is 10.13.1.

    why?

  • 1 vm deployment, Lync 2013 standard with sql express 2012

  • @Nick

    Make sure that you also ran Step 3 from KB2809243 to apply any updates to the CMS.

  • @dodeitte

    thx man, after

    get-csmanagementconnection

    and

    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?

  • @Russell

    Yep. I just updated the post with information on mgccomp.

  • Hi Doug
    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.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment