What are all the Lync Databases for?

Tried to give a customer a quick verbal re the databases as seen in their SQL backend on the fly…Surprisingly I only missed one 😉
Better chuck that in the blog for quick reference then
Xds – aka the CMS, contains the published Topology
RTC – persistent user data including contact lists, scheduled conferences
Rtcdyn – Presence info
Rtcab – address book data (synced from AD)
Rtcab1 – address book data (synced from AD)
Cpsdyn – Call Park data, dynamic
Rgsdyn – RGS data, dynamic
Rgsconfig – RGS config
LcsLog – IM and Conference data for Archiving
LcsCdr – CDR
QoEMetrics – QOE Data
Lis – Location and information service

Log file placement defined here

The DB names are hardcoded. You can only choose the SQL instance name, and port numbers.


About Paul B

My name is Paul Bloem and I am employed at Lexel Systems in New Zealand as a Principal Consultant for Unified Communications. I have been working on enterprise voice solutions for over 20 years. My first 10 years were spent working for a Telco in South Africa (Telcom SA). This is where all the groundwork happened as I was exposed to just about every aspect of telecommunication you could imagine. I develop an interest in PBX technologies and eventually became the go-to guy. Next, I had a 10 year run at Siemens South Africa, most of my time there was as a Technical Trainer. During this time VoIP hit the world stage, I had the privilege of introducing VoIP both as H.323 and later SIP across the Siemens HiPath 4000 solution stack. In 2008 I immigrated to New Zealand with my newly attained MCSE, I was ready to go where no PBX Techie had gone before. I was employed to explore OCS 2007 and that was pretty much the beginning of the end for me. I have been working on OCS and Lync ever since. My current role focuses exclusively on Lync and associated technologies.. That includes pre-sales, consulting, architecture and design, training and support. I even get to play in the development space from time to time - focus on play ;-) I was nominated as a Microsoft VTSP for Lync early in 2013 and also awarded Microsoft's MVP award for Lync in 2014.
This entry was posted in CMS, Databases, RTC Database, SQL. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s