Examining Supported SQL Server Editions
SharePoint 2010 supports SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. However, if planning for database mirroring, it is strongly recommended to deploy a version of SQL Server 2008 or SQL Server 2008 R2 to take advantage of the core performance enhancements for database mirroring. One of these major enhancements includes the ability to compress the stream of log records from the principal server to the mirror server, resulting in a sizable performance increase.
Table 17.2 lists the available database mirroring features within the supported versions of SQL Server 2005 and SQL Server 2008.
Table 17.2. Available Database Mirroring Features in SQL Server 2005 and SQL Server 2008
Caution
Although ...
Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
