Skype for Business Server 2015 Databases Purpose

skype-for-business

Skype for Business Server 2015 databases are as same as they were in Lync Server 2013. So this article is appliable for Lync Server 2013 as well. Skype for Business Server 2015 installs SQL Server 2014 Express Edition (64-bit) for local configuration databases while SQL Server 2014/SQL Server 2012 SP2 with CU2/SQL Server 2008 R2 SP2 can be deployed for Back End databases, Archiving, Monitoring, Persistent Chat and Persistent Chat Compliance databases. Below are the graphical representation of databases placement in Standard and Enterprise Edition.

Skype for Business (Lync Server) databases architecture overview

Important note is that copies of databases are installed as following:

  • Master databases installed on SQL BackEnd server and copy of database is installed locally on each Front End Server (SQL Express) in case of Enterprise Edition FrontEnd Pool.
  • Both Master and copy of of databases are installed on Front End Server in case of Standard Edition Front End Pool was deployed.

The graphical representation of Skype for Business databases location can be found below:

Standard Edition:

Skype-for-Business-databases-standardEnterprise Edition:

Skype-for-Business-databases-enterprise

Skype for Business Application Databases

  • CPsdyn: contains dynamic information used by Call Park application like “Orbits”.
  • RGSConfig: contains the configuration of Response Groups, like Agents, Workflows, Queues, Holidays…
  • RGSDyn: contains dynamic “live” information used by the Response Groups.

Skype for Business Archiving & Monitoring Databases

  • LCSLog: archives information about Instant messaging sessions, P2P calls and conferencing used by the archiving server.
  • LCSCdr: stores the call details records used by the monitoring server.
  • QoEMetrics: stores information about Quality of Experience used by the monitoring server.

Skype for Business Central Management Databases

  • XDS: this is the Skype for Business Central management Store (CMS) database, it holds topology, configuration and polices.
  • LIS: stores location information (network subnets, ports, switches…etc.) that is used by Skype for Business Location Services for E9-1-1 feature.

Skype for Business Core Databases

  • RTC: stores persistent user information (contact list, contact groups, scheduled conferences…etc.).
  • RTCDyn: Store dynamic “live” data about users (current presence, endpoints user logged in from…etc.).
  • LYSS: “lyss” stands for Lync Storage Service and maintains HA within a FE pool. It is a blob database and abstract writes to backend database. It maintains a copy of the data within Front End servers in the pool temporarily, and delete that data once it has been delivered to the final database server. It is a replacement for MSMQ which was used in previous version of Lync. Therefore, it is part of the Front End servers and it is located under LYNCLOCAL named instance. It is also used for Archiving integration and Unified Contact Center. Currently, it supports Exchange and SQL for archiving.

Skype for Business Users Databases

  • RTCAB: stores the Skype for Business address book information used by Skype for Business address book services.
  • RTCXDS: stores a back up of user data.
  • RTCSHARED: hosts the conferencing directory
  • MGC: maintains user persistent chat data.
  • MGCCOMP: maintains compliance data persistent chat.

To check databases on Front End Servers use SQL Management Studio to connect by specifying FRONTENDNAME\SQLINSTANCENAME and credentials with rights enough to connect:

connect-front-end-sql-databaseUsually there are two instances installed on Front Ends: RTCLOCAL and LYNCLOCAL.

Want me to do this for you? Drop me a line: itgalaxyzzz {at} gmail [point] com