Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SP1 and SP2 on same server but different instances? Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 2:00 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
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.
Post #449680
Posted Wednesday, January 30, 2008 3:45 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
Yes. When you apply service pack, you can choose what instance(s) you would like to apply the service pack.
Post #449724
Posted Thursday, January 31, 2008 10:59 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Thanks. You made my day. I know it works in SQL Server 2000 but never tried it with SQL server 2005.

SQL DBA.
Post #450098
Posted Friday, February 1, 2008 6:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 1:34 PM
Points: 1,276, Visits: 2,803
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 ?


Post #450420
Posted Friday, February 1, 2008 12:11 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
How about considering each instance as a standalone server separated from others? That is what in my mind.
Post #450696
Posted Friday, February 1, 2008 1:20 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
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.
Post #450737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse