Microsoft SharePoint Team Blog
The official blog of the Microsoft SharePoint Product Group


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:

Windows SharePoint Service 3.0
http://technet.microsoft.com/en-us/library/cc288751.aspx
Office SharePoint Server 2007
http://technet.microsoft.com/en-us/library/cc262485.aspx
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

Published Friday, August 15, 2008 3:38 PM by sptblog
Filed under: WSS 3.0, MOSS 2007, SQL


source : http://blogs.msdn.com/sharepoint/default.aspx