How to upgrade to SP2 on active/active

#1

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#2

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#3

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#4

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#5

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#6

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#7

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#8

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#9

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks

#10

Once you've applied the SP to a DBMS on a cluster, you don't have to reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote

Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to node 2
4- Reboot node 1
5- Log on node 2 and install the SP2 on the two instances
6- Failover node 2 and node 1 ressources to node 1
7- Reboot node 2
8- Failover node 2 ressources to node 2

It seems too simple .... I'm I forgetting sometings ?

Thanks