SharePoint Server 2010 Functionality and SQL Server Editions Comparison SharePoint Server 2010 SQL Server 2008 R2 SQL Server 2008 R2 SQL Server 2008 R2 SQL Server 2008 SQL Server 2008 SQL Server 2008 SQL Server 2005 SQL Server 2005 Functionality Enterprise Standard Express Enterprise Standard Express Enterprise Standard SharePoint Server 2010 64-bit only 64-bit only 64-bit only 64-bit only 64-bit only 64-bit only 64-bit only 64-bit only Service Pack (SP) 1, SP1, CU2 SP3 CU3 SP3 CU3 Cumulative Update required, CU5 or required required (CU) 2 required, CU5 later or later recommended recommended Remote BLOB storage (RBS) on a non-local X X device Requires RBS add-in from the SQL Server 2008 R2 Feature Pack. RBS on a device. Requires RBS add-in X X X X X X from the SQL Server 2008 R2 Feature Pack. Backup compression X X X Data compression for the Search and X X Property databases Table partitioning for Web Analytics X X Reporting databases Transparent data encryption X X Resource governor X X Database auditing X X Clustered database server X X X X X X (faster recovery) 2 nodes only (faster recovery) 2 nodes only (faster recovery) 2 nodes only
SharePoint Server 2010 Functionality and SQL Server Editions Comparison SharePoint Server 2010 Functionality SQL Server 2008 R2 Enterprise SQL Server 2008 R2 Standard SQL Server 2008 R2 Express SQL Server 2008 Enterprise SQL Server 2008 Standard SQL Server 2008 Express SQL Server 2005 Enterprise SQL Server 2005 Standard SharePoint Server 2010 64-bit only 64-bit only 64-bit only 64-bit only Service Pack (SP) 1, Cumulative Update (CU) 2 required, CU5 or later recommended 64-bit only SP1, CU2 required, CU5 or later recommended 64-bit only 64-bit only SP3 CU3 required 64-bit only SP3 CU3 required Remote BLOB storage (RBS) on a non-local device Requires RBS add-in from the SQL Server 2008 R2 Feature Pack. X X RBS on a device. Requires RBS add-in from the SQL Server 2008 R2 Feature Pack. X X X X X X Backup compression X X X Data compression for the Search and Property databases X X Table partitioning for Web Analytics Reporting databases X X Transparent data encryption X X Resource governor X X Database auditing X X Clustered database server X (faster recovery) X 2 nodes only X (faster recovery) X 2 nodes only X (faster recovery) X 2 nodes only