SQL Server 2008 Support for SharePoint Products and Technologies
You may already be aware of the recent RTM announcement of SQL Server 2008. We are happy to announce that Office SharePoint Server 2007 SP1 & Windows SharePoint Services 3.0 SP1 now support SQL Server 2008. Our documentation has been updated to include support for SQL Server 2008. Please refer to:
In the next few weeks, we will publish a TechNet article that describes the benefits of running SQL Server 2008 with SharePoint Products and Technologies. Here, we’ve highlighted a few of the benefits that SharePoint customers inherit when choosing to use SQL Server 2008:
1. Improved Manageability
Manageability and governance is important for SharePoint as well as the SQL Server database engine. Now administrators can also benefit from the new management features introduced in SQL Server 2008 – from Policy-based administration to back-up compression. For details, please refer to http://technet.microsoft.com/en-us/library/cc645579(SQL.100).aspx.
2. High Availability
Availability in SQL Server 2008 has been improved through enhancements in data mirroring. For details, please refer to http://technet.microsoft.com/en-us/library/cc645581(SQL.100).aspx.
3. Enhanced Data Security
The SQL Server 2008 database engine introduced new encryption functions that enhance security. SharePoint administrators can take advantage of these new encryption features by simply turning on transparent data encryption (TDE). No additional changes need to be made on the SharePoint side. For details, please refer to http://technet.microsoft.com/en-us/library/cc645578(SQL.100).aspx.
Last but not least, don’t forget to apply SP1 on SharePoint Server 2007 and Windows SharePoint Services 3.0. Keep in mind, SP1 is also a requirement for installing on Windows Server 2008.
Stay tuned for the TechNet article!
Jie Li
Technical Product Manager, SharePoint
