Re: migrating a SQL Cluster to new hardware

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Before eviting the nodes, you have to run the SQL installer to remove the node from the SQL cluster configuration. You cn run it afterwards and force it out, but that takes longer. You also have to run the installer and install SQL to the new nodes. You then need to re-apply any service packs.

GNH


"Amila chandrasekera" <achandra@xxxxxxxxxxx> wrote in message news:OGAFgGFUHHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the replies so far. This migration is from SQL 2000 to SQL 2000 (both source and target are running on Windows 2003 Advanced server). I am not planning to do a SQL 2005 upgrade with this migration. It is purely a hardware upgrade only.

Here is what I am thinking of doing.
Asume Node1 and Node2 are the current production SQL cluster nodes.
Node3 and Node4 are the new servers.

1. Move all cluster roles to Node1
2. Evict node2 from the cluster
3. Conect Node3 and join it to the cluster
4. Move all cluster roles to Node3
5. Evict Node1 from cluster
6. Connect Node4 and join it to the cluster
7. Connect Node3 and Node4 to the new SAN (while connected to the old SAN )
8. Setup Quorum and data stores in the new SAN
9. Move Quorum to the new SAN
10. Shutdown the SQL Server
11. Copy SQL DBs from old SAN to the new SAN. Change Drive letter mappings to maintain the paths.
12. Disconnect old SAN connection completely.
13. Start SQL Server

Is this feasible ? Am I missing anything here ?



"Amila chandrasekera" <achandra@xxxxxxxxxxx> wrote in message news:%23h6t5u7SHHA.412@xxxxxxxxxxxxxxxxxxxxxxx
I need your advise on migrating a two node SQL 2000 cluster to new hardware including servers and disks.


thanks.
Amila




.

Relevant Pages

  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Newbie - SAN Advice
    ... A SAN generally has gigabtes of cache and uses large internal block sizes ... The SAN or Smart array will dictate what internal connection the disks have. ... Senior SQL Infrastructure Consultant ... single-instance cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... Do you want to cluster SQL? ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)