August 28, 2007 at 1:44 pm
I can't find any information about applying service packs if you install another feature after appling the service pack. For example: I install 2005 SQL server & SSIS. I then aply service packs. Later it becomes necessary to install Reporting Services. Do I need to apply the service packs again? If so is there a special install of the service packs? Or do I run the full service pack install? Please advise.
August 28, 2007 at 2:28 pm
Yes.
The service pack checks for installed products and updates them accordingly. When you install a new feature, you'll need to apply service packs accordingly to update that feature.
September 1, 2007 at 11:42 am
In general this is true, but don't expect that just because you applied the service pack, the recently added service has been updated.
In my experience with SQL 2005, SP1 seems to check the Database server version to determine if it can be applied. If the database version isn't SP1 or less, it won't apply anything.
This means that if you install SQL 2005, apply SP1, apply the post SP1 security update, install additional SQL 2005 services, and apply SP1, your additional services won't get updated.
I've found the only way to get additional services added to a post SP1 patched SQL 2005 server is to uninstall SQL completely, copy the data files elsewhere, install the components you need (including the service packs and patches), and copy database files (including master) back to their original locations.
SQL 2005 SP2 and the post SP2 updates seem to do a much better job about checking the version on ALL components and updating anything that isn't at least at the SP level. However, I haven't tested updating to a post SP2 security update and then adding services.
I'm beginning to think the best way to install SQL is to install all components and disable those not known to be needed, but I hate to do this because it means having IIS running in order to install Reporting services.
September 13, 2007 at 10:21 am
Aaron/Scott,
Thank you both for your answers and sorry it has taken me so long to get back to this. I was at level 3054, so I ran SP2 again and it applied the patch to just analysis services and reporting services. I then ran GDR2 for 3054 and again it only applied to those two services.
One question it brought up though, was that I ran
SELECT
SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
and it only showed me the Enterprise Edition and that it was at 3054 through out the whole procedure. This made me wonder "How do you query or what module do you run to see the service pack level of each component (SQL server, Analysis server, etc.)? Any suggestions would be appreciated.
Tony
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply