Doug Deitterick's Blog

Information about Skype for Business, Lync, OCS, and Exchange UM.
Options
Search Blogs
Tags
Archive
Archives

How to Verify if Lync Server 2013 Database Updates Completed Successfully

TechNet Blogs » Doug Deitterick's Blog » How to Verify if Lync Server 2013 Database Updates Completed Successfully

How to Verify if Lync Server 2013 Database Updates Completed Successfully

dodeitte dodeitte
2 Jul 2013 8:02 PM
  • Comments 16
  • Likes

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: 

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
October
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

November
2014

 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.3 62.90.1 10.13.2 3.1.1

December 2014

 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.3 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
October 2014 1.42.2 1.7.0
November 2014 1.42.2 1.7.0
December 2014 1.42.2 1.7.0
Comments
Comments
  • Anonymous Dharmesh
    11 Sep 2013 2:49 PM

    Awesome info.  Thanks for the post it has been most helpful.

  • Alessio Giombini Alessio Giombini
    13 Sep 2013 5:55 PM

    very useful, thanks.

  • Anonymous Tom Arbuthnot
    14 Oct 2013 10:51 PM

    Thanks Doug, really helpful.

    For Easy Reading of current version:

    Test-CsDatabase -ConfiguredDatabases -SqlServerFqdn sql01.tomuc.int | Select-Object databasename,installedversion

  • Nicolas BROISIN Nicolas BROISIN
    1 Nov 2013 1:08 PM

    Thanks for the update when each CU is published. Very nice :)

  • Anonymous Nick
    21 Nov 2013 2:18 PM

    hello,

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

    why?

  • Anonymous Nick
    21 Nov 2013 2:19 PM

    1 vm deployment, Lync 2013 standard with sql express 2012

  • dodeitte dodeitte
    21 Nov 2013 3:25 PM

    @Nick

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

  • Anonymous Nick
    22 Nov 2013 12:16 PM

    @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.

  • Anonymous Anonymous
    11 Jan 2014 5:12 AM

    No need to even hardcode the SQL server in many environments. Test-CsDatabase -ConfiguredDatabases -SqlServerFqdn (Get-CSService -UserDatabase).PoolFqdn | Select-Object DatabaseName,Installed*,Expected*

  • Anonymous Cole
    9 Mar 2014 7:49 AM

    After running the database updates Lync Mobile stopped working on iPhones.

  • Anonymous Russell
    3 Apr 2014 4:03 AM

    Do you have the mgccomp database details for Installed Versions of the different Cumulative Updates?

  • dodeitte dodeitte
    8 Apr 2014 1:51 AM

    @Russell

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

  • Alessio Giombini Alessio Giombini
    10 Sep 2014 10:15 AM

    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