SAN Migration step for SQL Cluster DB server from one storage to new storage

Requirement: We have a requirement to migrate our Storage from NetApp to HP as our organization migrating all our storage to HP. Presently we have NetApp storage .We have Standalone and cluster SQL servers.The migration of standalone servers is easy but we had the challenge to M

 
 
 
 
 
4.2 Star
(9)
4,340 times
Add to favorites
Databases
11/19/2013
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Copy Files using windows expolore
    1 Posts | Last post February 19, 2019
    • 
      
      7	Open Windows Explorer and copy the SQL data from the old drive to the new drive
      8	Open Windows Explorer and copy the SQL Log from the old drive to the new drive
      
      Is it recommended just copy SQL Data and log to new SAN and start SQL Cluster. As I found, it is recommended to take native backup (SQL backup) and restore to new SAN drive. 
  • No separate MSDTC group
    1 Posts | Last post September 14, 2017
    • Couple of differences encountered on our Windows 2008R2 cluster. There was no separate MSDTC group, it shows as a resource under each service.
      
      Also we were unable to see the new witness/quorum disk in the Dependency property so had to select the Root disk, when it was added later.
  • WinSvr2012 + SQL2012
    1 Posts | Last post June 22, 2017
    • Does this procedure applies to Windows Server 2012 + SQL 2012?
      
      Thanks and regards,
      
      Joseph Liu
  • DB Mirroring
    1 Posts | Last post February 08, 2017
    • We are migrating our organization's data from one SAN to another SAN (Array - Array migration)
      
      I've a clustered SQL servers which is configured with DB mirroring. When I take SQL offline and bring it back online.
      The databases using mirroring(Principal and mirror servers) will be impacted or it will be in synchronized state as before.
      How can you determine this kind of situation ? Any advise? 
  • MSDTC Note
    1 Posts | Last post January 26, 2017
    • Another note to add.  We had to customize the security properties of our MSDTC through dcomcnfg.exe.  You will want to record the settings for the clustered MSDTC since they will be lost when deleting and recreating.
  • FileServices
    1 Posts | Last post January 18, 2017
    • Hi
      How would you go about moving FileServer cluster from 1 disk to another?
      
      I have storage replication between the two appliances, would not changing the disk UUID resolve, the necessity of using robocopy, etc?
  • LUN size
    2 Posts | Last post January 15, 2017
    • Hello,
      Is it a necessary condition to prepare new LUNs from the new storage with the same size as the old storage? Can I prepare LUNs with smaller size?
    • Hi,
      
      You can prepare the new LUNs as per the DB size.No need to have same size LUNs.
  • Cluster SAN Disk Migration
    2 Posts | Last post July 27, 2016
    • Hello,
      
      don't we need to use the robocopy to transfer the SQL MDF and LDF data and do we need to Stop the SQL resource while transfer the data to another disk
      
      don't we used Failover Cluster Manager that has a built in ‘repair’ functionality to replace the disks.
    • The service must be stopped during the migration.  Maybe your SAN admin can help with speeding the transfer or doing some kind of snapshotting, but typically this is not the case when moving to a new SAN which may be from a different vendor.  If you still needed less down time, look into using some of the HA/DR features to set up a mirror or log shipping secondary on a new server that you would cut over to.
  • permissions
    1 Posts | Last post July 27, 2016
    • Hi,
      
      Using explorer to copy files will lose permissions.  You should use xcopy instead.  
      
      This would move all files and permissions from N: to X:
      
      xcopy N:\*.* X:\ /O /X /E /H /K
      
      Thanks for the steps.
  • Add a wiki document for the same
    1 Posts | Last post January 28, 2014
    • Let everyone to view and provide the comments