October 25, 2007 at 7:39 am
I have an existing multi instance SQL 2000 cluster with 3 nodes. I have each instance running on one of the nodes so they are all active at any given time. We have been considering an upgrade to SQL 2005 and I have been doing some research. However, I cant seem to find a process to do an in place upgrade with the type of cluster we have.
I have found how to handle fail over cluster upgrade but am looking for multil instance active/active upgrade. Can anyone point me to some links and also maybe share some opinions on if it even makes sens to upgrade from 2000.
I am in a shared web hosting environment, so we are not suing for any ERP's or other heavy applications. These are customer databases that are being used on a very small scale. There are however over 1000 dbs per instance..
Thanks for any guidance
October 31, 2007 at 2:05 pm
i've never done a 3 node cluster, but with our 2 node it's always like this
fail over to one node
upgrade an instance
fail over to the other node
upgrade the other instance
make sure you have checked workstation tools and SSIS if you need it on both nodes so the local files get installed on each node
in your case i would fail over to the third node and upgrade the last instance
for SP2 i would do the same thing, but i found that it upgrades everything on all nodes so the failing over would just be verification that all the components were upgraded
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply