Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

SharePoint Forum

:

Wiki: SharePoint Server 2010 Functionality and SQL Server Editions Comparison

SharePoint Server 2010 Functionality and SQL Server Editions Comparison 

Reference: http://technet.microsoft.com/en-us/library/cc990273.aspx

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 local 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 Crawl 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