Steps to Uninstall SQL Server 2008 Service Pack 1 (SP1) 1. The database backups will help you to roll SQL Server back to the same state as it was, prior to the un-installation of SQL Server 2008 Service Pack 1 (SP1).

I'm still baffled by how many people think these are the same overall version – and I curse Microsoft for their naming choice. The Resource database is a read-only database that contains all the system objects that are included with SQL Server. UPDATE : I have confirmed that the security update from June's Patch Tuesday (which I discussed here and here) is included in the service pack.Īnd no, this service pack is not for SQL Server 2008, it is ONLY for SQL Server 2008 R2. …and by investigating the fixes in each of the first 6 cumulative update packages (they won't all be listed in the KB above):Īs described in the following blog post from the Release Services team, Service Pack 1 does not include the fixes from Cumulative Update 7 or Cumulative Update 8: More changes you might not have noticed in SQL Server 2008 R2 SP1 CTPĪnd you can read about the fixes that are included by reading KB #2463333: SQL Server 2008 R2 SP1 CTP is now available You can read about some of the changes in Service Pack 1 (no, it is not just a bunch of fixes) in these blog posts: Build with the latest Windows Visual Studio C++. Microsoft SQL Server 2008 R2 (SP1 ) - 10.

Sql server 2008 sp1 express