October 2010
Intermediate to advanced
1008 pages
46h 16m
English
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
Although ...
Read now
Unlock full access