Database software support

Topic Last Modified: 2013-10-17

The following list contains the database management systems for the back-end database, the Archiving database, the Monitoring database, the Persistent Chat database, and the Persistent Chat compliance database that are supported by Lync Server 2013:

Back-end database of a Front End pool, Archiving database, Monitoring database, persistent chat database, and persistent chat compliance database
- Microsoft SQL Server 2008 R2 Enterprise database software (64-bit edition). Additionally running the latest service pack is recommended.
- Microsoft SQL Server 2008 R2 Standard (64-bit edition). Additionally running the latest service pack is recommended.
- Microsoft SQL Server 2012 Enterprise (64-bit edition). Additionally running the latest service pack is recommended.
- Microsoft SQL Server 2012 Standard (64-bit edition). Additionally running the latest service pack is recommended.

Standard Edition server database and local configuration store databases

Microsoft SQL Server 2012 Express (64-bit edition). Additionally running the latest service pack is recommended.

Note:
Microsoft SQL Server 2012 Express (64-bit edition) is automatically installed by Lync Server 2013 on each Standard Edition server and each Lync Server 2013 server on which the local configuration store is deployed.

Important:
Lync Server 2013 does not support the 32-bit edition of SQL Server. You must use the 64-bit edition. SQL Server Web edition and SQL Server Workgroup edition are not supported. You cannot use them with Lync Server 2013. Lync Server 2013 does support native database mirroring. To use the Monitoring Server role, you should install SQL Server Reporting Services.

In a Front End pool, the back-end database can be a single SQL Server computer.

For more information and best practices for failover clustering in SQL Server 2012, see http://technet.microsoft.com/en-us/library/hh231721.aspx. For failover clustering in SQL Server 2008, see http://technet.microsoft.com/en-us/library/ms189134(v=sql.105).aspx.

Important:
If you collocate Lync Server databases with other databases, we highly recommend assessing all factors that might affect availability and performance, as well as ensuring that, if one node fails, the remaining node can handle the load. To verify failover capabilities, we recommend testing all failover scenarios.

Using SQL Mirroring and SQL Clustering

Lync Server 2013 supports the use of either SQL mirroring or SQL clustering for each Lync Server database. You can easily set up SQL mirroring with the Topology Builder tool in Lync Server 2013. For SQL failover clustering, you must use SQL Server for setup.

Lync Server 2013 supports SQL clustering topologies for all deployments, including greenfield deployments and organizations that have upgraded from previous versions of Lync Server.

SQL Clustering support is for an active/passive configuration. For performance reasons, the passive node should not be shared by any other SQL instance.

The following support is included:

Two-node failover clustering for the following:
- Microsoft SQL Server 2012 Standard (64-bit edition). Additionally running the latest service pack is recommended.
- Microsoft SQL Server 2008 R2 Standard (64-bit edition). Additionally running the latest service pack is recommended.
Up to sixteen-node failover clustering for the following:
- Microsoft SQL Server 2012 Enterprise (64-bit edition). Additionally running the latest service pack is recommended.
- Microsoft SQL Server 2008 R2 Enterprise database software (64-bit edition). Additionally running the latest service pack is recommended.

For more information about SQL mirroring, see Back End Server high availability. For details on how to deploy SQL clustering, see Configure SQL Server Clustering.