November 26, 2008 at 7:34 am
Dumb question perhaps, but as you can have multiple instances of SQL Server and have to apply service packs to each instance, when you want to set up a new instance and your installation media is at a lower service pack level than that currently installed what happens?
It appears that the admin tools are expecting a newer service pack instance. Will the tools get overwritten by the new install and end up with older versions?
Obviously once installed the new instance can have the service pack applied but as this is on a "production server" we can't afford for the installation to got wrong.
TIA for any advice.
November 26, 2008 at 7:42 am
I assume you mean the client tools when you talk about admin tools. When you install a new instance it will detect that these are already installed and won't reinstall these.
Installing a new instance won't overwrite any files of the existing instances. So you're safe.
It's a different story if you add features like SSIS or SSAS to an existing instance. In that case you must reinstall the SP after adding the new features.
[font="Verdana"]Markus Bohse[/font]
November 26, 2008 at 8:46 am
Be aware that some subsystems, like SSIS, are not instance aware. They can be installed only once on a particular host server. If SSIS is installed, it's available in all instances.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply