March 30, 2004 at 1:31 am
Hi everybody,
Has anybody changed server machines in cluster environment?
We have Sql Server 2000 environment , two instances, no replication, few links between servers.
OS is Win 2000 Advanced server.
No we have to replace the Sql Server machines with new ones.
All our databases are in Raid-system (including sys dbs) which will not change. So we don’t physically have to move anything. IP-addresses will be the same also.
Current testing databases are on temporary disks.
After we have configured the new cluster to use our production Raid-system
1) we have to change startup parameters and restart SQL server.
2) and probably have to change some file paths in registry.
Is there something else we should do?
Thanks in advance
-Katja
Katja Lehtinen
April 2, 2004 at 8:00 am
This was removed by the editor as SPAM
April 2, 2004 at 8:18 am
Can the new machines interface with your shared storage where the data already exists? If so, you could do something similar to (this is all high-level)...
1) Put both instances on one node (server).
2) Remove SQL Server from the second node (see http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part4/c1261.mspx
3) Revoke the second node from the cluster
4) Disconnect the second node
5) Plug in the first replacement system
6) Bring it into the cluster
7) Install SQL Server on the new node
8) Move SQL Server resources over to it
9) Repeat 2-7 to replace the 1st original node
10) Reapply service packs
Like I said, this is high level and I'd go back through the relevant Microsoft literature on clustering, etc. I've had to replace a failing node before and we basically followed steps 2-8 with Microsoft's technicians on-site.
K. Brian Kelley
@kbriankelley
April 29, 2004 at 3:28 pm
I am faced with a similar taske except I am replacing/upgrading the entire cluster storage as well as the CPU's. Any ideas on how to accomplish this task.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply