Considerations for SPOR with SQL Server

The following applies to both Clustered and Non-Clustered SQL Server platforms:

• When using SQL Server 2005, (32 bit or 64-bit) as your database server, you must install Microsoft SQL Server 2005 SP2, or a later version of that service pack. In addition, you must also install the Microsoft SQL Server 2005 Backward Compatibility Components for SQL Server package, which is one of the components of the Microsoft SQL Server 2008 Feature Pack, August 2008 installation package collection, and is available for download from the Microsoft Download Center website. The Microsoft SQL Server 2008 Feature Pack, August 2008 installation package collection contains many different items, but you will only need to install the Microsoft SQL Server 2005 Backward Compatibility Components for SQL Server package.

• SPOR does not support SQL 2000 database servers. If you use SQL Server 2000, you will be able to back up your databases using the SharePoint application and restore whole databases, but you will not be able to do an item-level restore from those backups.