Database Software and Clustering 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, Group Chat database and Group Chat compliance database that are supported by Microsoft Lync Server 2010:

• Back-end database of a Front End pool, Archiving database, Monitoring database, Group Chat database and Group Chat compliance database

  • Microsoft SQL Server 2008 R2 Enterprise database software (64-bit edition) or latest service pack (recommended)

  • Microsoft SQL Server 2008 R2 Standard (64-bit edition) or latest service pack (recommended)

  • Microsoft SQL Server 2008 Enterprise (64-bit edition) with Service Pack 1 (SP1) (required) or latest service pack (recommended)

  • Microsoft SQL Server 2008 Standard (64-bit edition) with SP1 (required) or latest service pack (recommended)

  • Microsoft SQL Server 2005 Enterprise (64-bit edition) with Service Pack 3 (SP3) (required) or latest service pack (recommended)

  • Microsoft SQL Server 2005 Standard (64-bit edition) with SP3 (required) or latest service pack (recommended)

• Standard Edition server database and local configuration store databases

  • Microsoft SQL Server 2008 Express database software (64-bit edition) with latest service pack (recommended)

  Note

  SQL Server Express (64-bit edition) is automatically installed by Lync Server 2010 on each Standard Edition server and each Lync Server 2010 server on which the local configuration store is deployed.
  Lync Server 2010 supports manually upgrading each SQL Server 2008 Express database to SQL Server 2008 R2 Express (64-bit edition), after the initial deployment of each Standard Edition server and other Lync Server 2010 server on which the local configuration store is located.

Important

• Lync Server 2010 does not support SQL Server 2008 32-bit edition, SQL Server 2008 R2 32-bit edition, or SQL Server 2005 32-bit edition. 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 2010.

• Lync Server 2010 does not 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 computer running SQL Server. Alternatively, you can cluster two or more dedicated computers running SQL Server in a multiple-node active/passive configuration. A SQL Server cluster for the back-end database improves availability by providing failover capabilities. In a multiple-node cluster, the Lync Server 2010 SQL instance must be able to failover to a passive node that, for performance reasons, should not be shared by any other SQL instance.

SQL Server database clustering using Windows clustering is the only SQL Server high availability mechanism supported by Lync Server 2010. SQL Server clustering support includes the following:

• Two-node failover clustering for the following:

  • SQL Server 2008 R2 Standard or latest service pack (recommended)

  • SQL Server 2008 Standard with SP1 (required) or latest service pack (recommended)

  • SQL Server 2005 Standard with SP3 (required) or latest service pack (recommended)

• Up to sixteen-node failover clustering for the following:

  • SQL Server 2008 R2 Enterprise or latest service pack (recommended)

  • SQL Server 2008 Enterprise with SP1 (required) or latest service pack (recommended)

  • SQL Server 2005 Enterprise with SP3 (required) or latest service pack (recommended)

Important

If you collocate Lync Server databases with other databases, we highly recommend assessing all factors that might impact 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.