As promised SQL Server release services has done it again, a great job in releasing SQL Server 2008 Service Pack 2. Continung from SQL-2008-CU10 blog post here, it is recommended (I say MUST) to go through the SP2 release notes the download link confirms on :
Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting
Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces support for a maximum of 15,000 partitions in a database, and
includes SQL Server 2008 SP1 Cumulative Update 1 to 8. While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. Microsoft SQL Server 2008 Service Pack 1 is not a prerequisite for installing SQL Server 2008 Service Pack 2.
Also the instructions on how best you can download & review the setup documentation:
To view the SQL Server 2008 SP2 Setup documentation on the local computer,
do the following:
- Download and run SqlSP2_setuphelp.exe.
- Follow the instructions to extract the Help file.
- Find the location on the local computer where you saved the
- Double-click SqlSP2_setuphelp.chm to open the Help file.
Download the appropriate package as per your environment 32 bit or 64 bit or IA64 platform to test it first and then apply on the production instances.
Happy service packing....folks.