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 |