upgrading from 2000 to 2005 cluster

#31

On Dec 12, 4:02*pm, sql_noob <alent1... (AT) gmail (DOT) com> wrote:

Quote:

On Dec 11, 9:44*am, "Geoff N. Hiten" <SQLCrafts... (AT) gmail (DOT) com> wrote:

If you can do a side-by-side migration to another cluster, that would be
best. *If not, install a second instance and move the data files onceyou
have the new instance running correctly. *You will have to move disk
resources between cluster groups and fix dependencies.

The failure rate for in-place upgrades is just too high.

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

"Gopi" <gopi... (AT) gmail (DOT) com> wrote in message

news:%23XQlvj2WJHA.5052 (AT) TK2MSFTNGP04 (DOT) phx.gbl...

Hello

we are having SQL 2000 Ent in cluster mode (active passive), now we are
planning to upgrade to SQL 2005, any idea?

Regards
Gopi- Hide quoted text -

- Show quoted text -

last year we did 2 upgrades, one in-place and another side by side on
clusters

the first we just installed SQL 2005 over SQL 2000

the next time we moved to 2 new 64 bit clusters. detached db's on old
instances. uninstalled SQL. installed SQL on new cluster and our SAN
admin mapped the disk volumes on the EMC and then we just attached
db's, created logins, etc- Hide quoted text -

- Show quoted text -

Did the in-place upgrade go well?

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

upgrading from 2000 to 2005 cluster

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

Re: upgrading from 2000 to 2005 cluster - 12-17-2008 , 04:10 PM