As with every IT environment new elements and upgrades are becoming a daily task rather than being a yearly task few years back. One of the most consuming upgrade task is storage migration. Your boss has just bought this new shiny storage box & he got it installed by the vendor in the datacenter. Now he need you to move all your production workload to it in no time. Well, if you are in a totally virtualized enviornment and has no Microsoft Clusters in place, then this can be easy and dandy with features like VMware Storage VMotion(ah sorry Only VMware offer such a feature at the moment, but that is not our topic for the day. Anyway did you choose the right Virtualization Product? Hope So!). If you still in the physical world then this is much more work even for non clustered machines, but machines with Microsoft Clusters will be the ones to involve the most amount of work. In this Article I will show you how to migrate Microsoft SQL Cluster Data from your old SAN to a new one If MS Exchange is what you are looking for then look at: Migrating Exchange 2007/2003 Cluster to a new SAN. The same steps should work for:
Microsoft SQL 2000 Cluster Data Migration to a new SAN
Microsoft SQL 2005 Cluster Data Migration to a new SAN
Microsoft SQL 2008 Cluster Data Migration to a new SAN
Microsoft SQL Cluster Data Migration in Physical & Virtual world where RDMs are used
Note: a small modification might be required for Microsoft SQL 2008 & MS SQL Server 2008 R2.
Warning: Data Migration always involve a high risk. Always make sure you have a proper back in place before trying/carrying out such a procedure.
Moving Quroum drive in Windows Cluster:
- Take offline all cluster group and dependant services
- Add two 1 GB volumes label them tempQ and finalQ to the cluster group
- Make sure quorum and tempQ and finalQ is online.
- Move Quorum resource to tempQ
- Copy Dtclog from original Q Drive to finalQ
- Change Drive letter of Q to another letter
- Change Driver letter of finalQ to Q
- Move the Quorum to new Q
- Make sure all resource dependant on old Q its dependency is changed to finalQ
- Move tempQ and oldQ to a temp cluster group and disable them
- delete msdtc resource
- Open command line on both nodes, then run comclust on both nodes starting with node1 (don’t close the command prompt of node 1 till node 2 is finished)
- Ensure MSDTC is created and ok, then bring the rest of the resource back online and start testing the failover.
Moving SQL Data Drives to the new SAN:
- Format the new data disk and give it unused drive letter. And label it new S for example
- insert the new data disk new S to the sql cluster group.
- Ensure all the cluster groups are on node one, and take all the cluster groups offline
- Bring the S drive resource and the new S drive resource online
- Use synchrofolder or CloneDisk to copy S drive to the new S drive
- Change S drive letter and change new S drive letter to S
- Change dependencies of all resources dependant on S drive to new S
- Move S resource to the temp group.
- Take the S resource offline then bring it online again
- Bring the cluster group online then the SQL cluster group
- Test the failover.
OK, I have mentioned two tools in here to use for cloning the Drive. To find CloneDisk download just search in Google for CloneDisk22 as the exact file name of it is CloneDisk22.exe. The synchrofolder can be found by searching Google for: SynchroFolder_1481.exe. Sorry I did not provide a copy of these software due to copy rights and license reason, though you should be able to obtain a free copy or trail of either easily online which should give you enough time to carry out your migration. While these two tools are the one I tried, there is many others that could do the same job of cloning the disk. Please note that CloneDisk work on the block level where Synchros Folder work on the file level, where CloneDisk is my preferred method of the two as it ensure its a full clone block by block.
I hope this help some one! Please feel free to leave your questions or comments in the comments area below.
One Response to 'Microsoft SQL Cluster Data Migration to a new SAN'
Leave a Reply
Eiad Al-Aqqad, VCDX#89
VMware Canada PSO
- Backup Solutions (3)
- Blades (2)
- IBM Blades (2)
- Data Migration (2)
- EMC (1)
- VPLEX (1)
- How to (1)
- Management Software (5)
- Problem resolutions (0)
- Storage (19)
- Tips & Tricks (7)
- Tivoli (22)
- Tutorials (11)
- VMware (6)
- azhar: Really useful information Eiad THanks
- Mihai: thanks for the info Chip, very useful commands. starting from your example here we are another select: SELECT...
- MikeD: very helpful – but i hope we never need this precedure… thanks
- srinivas: Thanks for sharing such good article it is very useful to me. ch srinivas
- admin: How deeps is your pocket I guess ? Enjoy, Eiad
- TSM – IBM Tivoli Storage Manager Guru Blog: Microsoft SQL Cluster Data Migration to a new SAN
- TSM – IBM Tivoli Storage Manager Guru Blog: Migrating Exchange 2007/2003 Cluster to a new SAN
- IBM Tivoli Storage Manager Guru Blog: TSM
- How to Videos: Install IBM Systems Director 6 Common Agent on AIX | How to Install IBM Systems Director 6 Common...
- 8.3. Microsoft vShadow Transaction Consistent Database Cloning to a different server: Back to: IBM Tivoli Storage...
- Comparing Online Backup Services
- Veeam & PHD Virtual comparison
- IBM Tivoli Storage Manager support for VADP
- StarWind is Named a Finalist in The Storage Awards 2012
- PHD Virtual Monitor Review
- vSphere manual Disaster Recovery failback when using VMware SRM
- Migrating Exchange 2007/2003 Cluster to a new SAN
- Microsoft SQL Cluster Data Migration to a new SAN
- PHD Virtual Backup and Replication for VMware vSphere Review
- VMware ThinAPP Antivirus Best Practices