January 30, 2008 at 2:00 pm
We have a server with two instances of SQL Server 2005. Both the instances right now had SP1 applied on them. Now we want to upgrade SP2 on only one instance, ie. instance 2. Is it possible to keep one instance on service pack1 and other on service pack 2?
Thanks in Adv.
SQL DBA.
January 30, 2008 at 3:45 pm
Yes. When you apply service pack, you can choose what instance(s) you would like to apply the service pack.
January 31, 2008 at 10:59 am
Thanks. You made my day. I know it works in SQL Server 2000 but never tried it with SQL server 2005.
SQL DBA.
February 1, 2008 at 6:04 am
The question I would have is though how does having a different Service Pack on different instances effect Integration Services ? If you have alot of packages for both instances do you patch that or leave it at SP1? Will that cause problems ?
February 1, 2008 at 12:11 pm
How about considering each instance as a standalone server separated from others? That is what in my mind.
February 1, 2008 at 1:20 pm
Both instances are working good but we don't have any SSIS packages on both servers, so can't say how integration services would behave.
SQL DBA.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply