How to Verify if Lync Server 2013 Database Updates Completed Successfully


Update 5/12/16 – Added database versions for May 2016 Cumulative Update.
Update 4/13/16 – Added database versions for April 2016 Cumulative Update.
Update 1/3/16 – Added database versions for January 2016 Cumulative Update.
Update 12/14/15 – Added database versions for December 2015 Cumulative Update.
Update 10/1/15 – Added database versions for September 2015 Cumulative Update.
Update 7/10/15 – Added database versions for July 2015 Cumulative Update.
Update 5/1/15 – Added database versions for May 2015 Cumulative Update.
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.

You can find the Skype for Business 2015 database versions here.

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
February
2015
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.2 10.13.3 3.1.1
May 2015 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.4 62.90.2 10.13.3 3.1.1
July 2015 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.5 62.90.2 10.13.3 3.1.1
September 2015 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.5 62.90.2 10.13.3 3.1.1
December 2015 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.5 62.90.2 10.13.3 3.1.1
January 2016 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.5 62.90.2 10.13.3 3.1.1
April 2016 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.5 62.90.2 10.13.3 3.1.1
May 2016 15.13.2 5.0.1 62.42.3 5.5.1 2.2.1 1.1.2 24.40.0 39.82.5 62.90.2 10.13.3 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
February 2015 1.42.2 1.7.0
May 2015 1.42.2 1.7.0
July 2015 1.42.2 1.7.0
September 2015 1.42.2 1.7.0
December 2015 1.42.2 1.7.0
January 2016 1.42.2 1.7.0
April 2016 1.42.2 1.7.0
May 2016 1.42.2 1.7.0
Comments (35)

  1. Anonymous says:

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

  2. Anonymous says:

    very useful, thanks.

  3. dodeitte says:

    @Russell

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

  4. Alessio Giombini says:

    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.

  5. Anonymous says:

    @Jan Pettersson

    If you run a Test-CsDatabase after applying the February CU, you’ll see that the ExpectedVersion for the xds database is 10.13.3. Step 3 in the KB probably hasn’t been updated yet.

  6. Anonymous says:

    I have just check the database versions on our updated Skype for Business 2015 SE server, Archiving and Monitoring and Persistent Chat service and found them to be different to the May 2015 updates as listed above.Is there a new blog that will list updates
    for SfB 2015, or can it be combines with this?

  7. Anonymous says:

    @Rose

    That is expected behavior when you have SQL mirroring setup. It is because the databases on the mirror are in the mirror state. If you run a Get-CsDatabaseMirrorState you should see that the MirroringStatusonMirror parameter is set to Mirror for all of the
    databases. If you were to make some/all of the databases active on the mirror by running the Invoke-CsDatabaseFailover cmdlet and then run the Test-CsDatabase cmdlet for the mirror, it would return the InstalledVersion.

  8. Dharmesh says:

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

  9. Tom Arbuthnot says:

    Thanks Doug, really helpful.

    For Easy Reading of current version:

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

  10. Nicolas BROISIN says:

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

  11. nick says:

    hello,

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

    why?

  12. nick says:

    1 vm deployment, Lync 2013 standard with sql express 2012

  13. dodeitte says:

    @Nick

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

  14. nick says:

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

  15. Anonymous says:

    Pingback from … and I thought I saw a 2 » Blog Archive » Lync Server 2013 CU4 – January 2014

  16. Anonymous says:

    Pingback from … and I thought I saw a 2 » Blog Archive » Lync Server 2013 CU4 – January 2014

  17. Anonymous says:

    Pingback from How to Verify if Lync Server 2013 Database Updates Completed Successfully – Doug Deitterick’s Blog – Site Home – TechNet Blogs | JC’s Blog-O-Gibberish

  18. Cole says:

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

  19. russell says:

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

  20. Anonymous says:

    October 2013 CU’s for Lync Server 2013/2010, Lync 2013/2010, Lync Mobile 2013 and Lync Phone Edition

  21. Anonymous says:

    Microsoft has released CU January 2014 for Lync Server 2010/2013

  22. Jan Pettersson says:

    February CU states a newer version of XDS-database: 10.13.3
    But the instructions for installations does not talk about updating the CMS-database?

  23. Rose says:

    We have two SQL Database ( Principle and mirror), principle shows that update successfully installed and are up to dated. but when I run the command and target the mirror server, the installed version shows blank and does not meet the expected version.
    Kindly advice

  24. Anonymous says:

    You can find the Lync Server 2013 database versions here .
    KB2809243 , it is important to remember

  25. Tobie Fysh says:

    Hi, Can you update with 927 (Sept Security Update) and 933 (Sept/October CU).
    Thanks

  26. user says:

    Tobie Fysh, run Test-CsDatabase

  27. dodeitte says:

    @Tobie Fysh

    I’ve updated the tables with the September 2015 CU database versions.

  28. David Keight says:

    Excellent source of information – easy to follow and helped me prove my db’s were up to date in about 2 minutes.
    Thanks

  29. ML49448 says:

    @dodeitte
    How about the December 2015 CU?

  30. dodeitte says:

    @Michael

    I’ve updated the table with the December 2015 CU information.

  31. jim says:

    Microsoft states that If the Central Management Store is homed on a Lync Server 2013 Standard Edition Server or Enterprise pool that was previously updated with the Lync Server 2013 February 2015 cumulative updates, do not run the Install-CsDatabase -CentralManagementDatabase
    command. Is this true as February 2015 CU also brought DB updates?

  32. Glenn says:

    Doesn’t look like the January 2016 update had any DB updates, just wanted to clarify.

  33. dodeitte says:

    @Glenn

    I’ve updated the table with the January 2016 CU information.

  34. Eric says:

    I have a question. We have 2013 Standard with pool mirroring. I can run this command off of the “main” pool and works but not on the other pool. With Standard is there an SQL database for both pools or is it just housed on the “main” pool.