Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL 2000 cluster in-place upgrade to SQL 2005

 
   Database Forums (Home) -> Clustering RSS
Next:  Date format changed  
Author Message
Amy Lewis

External


Since: Apr 20, 2005
Posts: 3



(Msg. 1) Posted: Fri Nov 23, 2007 9:19 am
Post subject: SQL 2000 cluster in-place upgrade to SQL 2005
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

I have a 2 node (Active/Passive) SQL cluster running on 2 2003 nodes. I want
to upgrade this cluster to a SQL 2005 cluster. I know that I can do a side
by side migration and install a new instance of SQL cluster and then migrate
the DATA - but I would rather not do that. I would rather do an in-place
upgrade

So I put the SQL 2005 Enterprise DVD in and started the install - it ran the
advisor wizard - said everything was fine. I had to choose which Instance to
install - I currently have the named instance DATA as my SQL cluster
instance - it did recognize that it was installed. I choose to install SQL
Database services - right underneath this checkwas was a checkbox that said
"Create a clustered service" - I assumed I should check this - so I did. A
few more screens - I put in passwords and then it asked me for Group names -
when I tried to put in my existing group names for Server, etc - it was a no
go.

It seems like the setup program should have recognized that I am already
running a clustered SQL service - should I have not checked that checkbox
about Create new cluster? It seems like it wasn't going to upgrade the
existing cluster, just create a new one.

when I went back and unchecked that checkbox about create a clustered
service - none of those screens came up - but it just seemed like it was
going to create just a regular SQL instance - with the same name DATA as my
cluster.

So I backed out of the install - everything is still working fine - it
didn't touch my SQL 2000 cluster. Any advice about when I go to the do
install the next time? Should I be checking that box or not? Do I have to
create a new instance name? or can I just keep the current one?

 >> Stay informed about: SQL 2000 cluster in-place upgrade to SQL 2005 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Processor Upgrade on a sql cluster - In our environment we have a cluster active standby with a shared storage iscsi The two machines are Windows 2000 Advanced Server with Intel Xeon Single-Core 3.4Ghz with SQL Server 2000 Enterprise Edition. Now we want to sustitute these two with..

SQL 2000 instance upgrade to SQL 2005 Cluster - Customer is running a SQL 2000 system single instance, this SQL 2000 is installed on a cluster of 2 nodes but they are not clustering the SQL instance, easier even they are running SQL 2000 on a cluster, SQL is not clustered. They want to upgrade t...

Upgrade from 2k to 2k3 Cluster corrupted - We have a 2 Node SQL Cluster that I was trying to upgrade to win2k3 from win2k. In the process the cluster got completely corrupted. I followed some documentation online and did: Cluster Node <name> /ForceCleanup Now I don't even see HKLM/Clus...

2000 Cluster - We're going to have to move data to a new 2000 SP4 server. We want to cluster it down the road, probably Q4 of 2008, but can't do it right now. So here's my question: 1. What do I have to do to this new server to make sure it can be clustered abou...

Cluster Rolling upgrade question for SQL Server 2005 Stand.. - We have traditionally used a rolling upgrade method for moving to new hardware on a MS cluster. We would add one new node tp an existing 2 node cluster and install SQL Server to the new node. Once we get the new hardare all installed, we wpould..
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]