SP1 and SP2 on same server but different instances?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SP1 and SP2 on same server but different...

SP1 and SP2 on same server but different instances?

Rate Topic

Display Mode

Topic Options

Author

Message

SanjayAttray

Posted Wednesday, January 30, 2008 2:00 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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

SQL ORACLE

Posted Wednesday, January 30, 2008 3:45 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 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

SanjayAttray

Posted Thursday, January 31, 2008 10:59 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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

Markus

Posted Friday, February 01, 2008 6:04 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 2:16 PM
Points: 1,048, Visits: 2,215

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

SQL ORACLE

Posted Friday, February 01, 2008 12:11 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 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

SanjayAttray

Posted Friday, February 01, 2008 1:20 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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 »

Permissions