upgrade sql 2000 active/passive cluster to sql 2008

#1

hi

i have an active/passive sql sever 200+sp4 cluster and i need to upgrade
it to sql2008 cluster. the BOL is saying " to run the setup on passive
node first then active node & when i failover to passive node the
databases will be upgraded to 2008".

any best practices/steps i need to follow to upgrade with out any
issues. what if i run the setup on active node? will this be an issue?

thanks

#2

No it won't be a problem because the installer will not upgrade an active
node. You MUST do it in the order recommended. YOu cannot do it in any
other order.

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

"krishna" <kpxus (AT) dont_spam_yahoo (DOT) com> wrote

Quote:

hi

i have an active/passive sql sever 200+sp4 cluster and i need to upgrade
it to sql2008 cluster. the BOL is saying " to run the setup on passive
node first then active node & when i failover to passive node the
databases will be upgraded to 2008".

any best practices/steps i need to follow to upgrade with out any issues.
what if i run the setup on active node? will this be an issue?

thanks

#3

thanks hiten

Geoff N. Hiten wrote:

Quote:

No it won't be a problem because the installer will not upgrade an active
node. You MUST do it in the order recommended. YOu cannot do it in any
other order.

hi

[quoted text clipped - 7 lines]

thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...ering/201001/1

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

upgrade sql 2000 active/passive cluster to sql 2008

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

upgrade sql 2000 active/passive cluster to sql 2008 - 01-27-2010 , 08:15 PM

Re: upgrade sql 2000 active/passive cluster to sql 2008 - 01-27-2010 , 08:29 PM

Re: upgrade sql 2000 active/passive cluster to sql 2008 - 01-28-2010 , 02:38 AM