July 12, 2009 at 11:18 pm
Hi All,
We have 2 node active-passive sql 2005(32 bit) cluster installed on x64 Windows server 2003(x64). Right now this cluster server is using MSA storage for quorum and SQL server database (shared drives).
We are planning to migrate the shared drive storage from MSA to SAN storage drives and below is our plan of action,
* take backup of related application and all SQL databases
* Stop the cluster service on both the nodes
* Make hardware connectivity from SQL server nodes to SAN Server
* Present new SAN Luns with diffrent logical drives names other than quorum and SQL shared drive letters
* Copy quorum data and SQL database data to new drives
* Remove MSA storage
* Rename the SAN storage logical drive name to correct quorum and SQL logical drive name
* Restart cluster service and bring all cluster resources online
Please let me know that this plan will work and advise me for any other tasks to be included.
BR,
Parthi
July 13, 2009 at 2:07 am
July 13, 2009 at 9:43 am
What you suggest sounds similar to what I've done in the past.
Create Backups
Attach new LUNs to both nodes, make sure they can fail back and forth in a different Cluster Group.
Move LUNs to your SQL Cluster Group
Stop SQL
Copy Files
Change Drive letters
Restart SQL
July 16, 2009 at 2:39 am
Hi All,
Apologies for late sorry and Thank you for your valuable information.
It seems migrating SQL database to new SAN involves less complexity than moving Quorum data as it contains disk signature.
The following URL is helpful to understand the complexity,
There are different procedure followed in moving cluster server to new SAN.
The detailed steps are
http://russkaufmann.spaces.live.com/blog/cns!9628511B4C1D269C!303.entry
There are disk signature problem in quorum disk as per
BR,
Parthi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply