dbTalk Databases Forums  

Re: Urgent: Order of installation / Reboots

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering Re: Urgent: Order of installation / Reboots

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Re: Urgent: Order of installation / Reboots in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dragon
 
Posts: n/a

Default Re: Urgent: Order of installation / Reboots - 12-11-2007 , 11:40 PM





Anyone?

Thanks.

"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote

Quote:
Hi,

We have a MS cluster with two instances of SQL running on it (SQL 2000 Ent
and SQL 2005 Ent). Currently, SQL 2005 instance is on SP1. Tomorrow
morning we plan on installaing the following on this instance:

SQL Server Service Pack 2
SQL Cummulative Update Package 2
SQL Cummulative Update Package 3
SQL Cummulative Update Package 4

My questions is, do we need to reboot after installing each SP/update? My
plan is to install SP2, CU2, CU3, and CU4 all in a row and then reboot the
cluster server.

What is the recommended method and order of reboots? Do I need to worry
about anything additional during installations because of it being a
cluster?

Thank you.



Reply With Quote
  #2  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: Urgent: Order of installation / Reboots - 12-12-2007 , 04:52 AM





Applying SPs will need reboot. However I suggest you to test SPs on a test
machine first. See if you have any issues with them and so you'll be able to
make your plan yourself safely.

--
Ekrem Önsoy



"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote

Quote:
Anyone?

Thanks.

"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote in message
news:%23AtQ9QCPIHA.4712 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

We have a MS cluster with two instances of SQL running on it (SQL 2000
Ent and SQL 2005 Ent). Currently, SQL 2005 instance is on SP1. Tomorrow
morning we plan on installaing the following on this instance:

SQL Server Service Pack 2
SQL Cummulative Update Package 2
SQL Cummulative Update Package 3
SQL Cummulative Update Package 4

My questions is, do we need to reboot after installing each SP/update? My
plan is to install SP2, CU2, CU3, and CU4 all in a row and then reboot
the cluster server.

What is the recommended method and order of reboots? Do I need to worry
about anything additional during installations because of it being a
cluster?

Thank you.


Reply With Quote
  #3  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Urgent: Order of installation / Reboots - 12-12-2007 , 08:44 AM


SP2 first. The SP installer will advise whether you will need a reboot or
not. Most likely you will.

You only need to run SQL CU4 after that. Cumulative updates are
"cumulative". CU4 contains the changes in 2 and 3. Again, the installer
will tell you if a reboot is necessary. Plan on a reboot anyway, just for
scheduling and impact planning.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote

Quote:
Anyone?

Thanks.

"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote in message
news:%23AtQ9QCPIHA.4712 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

We have a MS cluster with two instances of SQL running on it (SQL 2000
Ent and SQL 2005 Ent). Currently, SQL 2005 instance is on SP1. Tomorrow
morning we plan on installaing the following on this instance:

SQL Server Service Pack 2
SQL Cummulative Update Package 2
SQL Cummulative Update Package 3
SQL Cummulative Update Package 4

My questions is, do we need to reboot after installing each SP/update? My
plan is to install SP2, CU2, CU3, and CU4 all in a row and then reboot
the cluster server.

What is the recommended method and order of reboots? Do I need to worry
about anything additional during installations because of it being a
cluster?

Thank you.


Reply With Quote
  #4  
Old   
Dragon
 
Posts: n/a

Default Re: Urgent: Order of installation / Reboots - 12-12-2007 , 02:53 PM


Thank you.


"Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Quote:
Applying SPs will need reboot. However I suggest you to test SPs on a test
machine first. See if you have any issues with them and so you'll be able
to make your plan yourself safely.

--
Ekrem Önsoy



"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote in message
news:uRF$AGIPIHA.4688 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Anyone?

Thanks.

"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote in message
news:%23AtQ9QCPIHA.4712 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

We have a MS cluster with two instances of SQL running on it (SQL 2000
Ent and SQL 2005 Ent). Currently, SQL 2005 instance is on SP1. Tomorrow
morning we plan on installaing the following on this instance:

SQL Server Service Pack 2
SQL Cummulative Update Package 2
SQL Cummulative Update Package 3
SQL Cummulative Update Package 4

My questions is, do we need to reboot after installing each SP/update?
My plan is to install SP2, CU2, CU3, and CU4 all in a row and then
reboot the cluster server.

What is the recommended method and order of reboots? Do I need to worry
about anything additional during installations because of it being a
cluster?

Thank you.



Reply With Quote
  #5  
Old   
Dragon
 
Posts: n/a

Default Re: Urgent: Order of installation / Reboots - 12-12-2007 , 02:56 PM


Geoff,

Thank you for your reply.

Unfortunately some of the information you suggested is not how it typically
should be. CU 4 does not include updates from CU 2 or 3. CU4 is only about
3MB in size while CU2 and 3 each one is about 250MB. I installed SP2,
rebooted, and then installed all three of the CUs in 2,3,4 order followed by
another reboot of both nodes in the cluster.

Thank you for your help.


"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote

Quote:
SP2 first. The SP installer will advise whether you will need a reboot or
not. Most likely you will.

You only need to run SQL CU4 after that. Cumulative updates are
"cumulative". CU4 contains the changes in 2 and 3. Again, the installer
will tell you if a reboot is necessary. Plan on a reboot anyway, just for
scheduling and impact planning.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote in message
news:uRF$AGIPIHA.4688 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Anyone?

Thanks.

"Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote in message
news:%23AtQ9QCPIHA.4712 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

We have a MS cluster with two instances of SQL running on it (SQL 2000
Ent and SQL 2005 Ent). Currently, SQL 2005 instance is on SP1. Tomorrow
morning we plan on installaing the following on this instance:

SQL Server Service Pack 2
SQL Cummulative Update Package 2
SQL Cummulative Update Package 3
SQL Cummulative Update Package 4

My questions is, do we need to reboot after installing each SP/update?
My plan is to install SP2, CU2, CU3, and CU4 all in a row and then
reboot the cluster server.

What is the recommended method and order of reboots? Do I need to worry
about anything additional during installations because of it being a
cluster?

Thank you.



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top