Sql-server – Precautions for moving a SQL cluster from an old to a new datastore

clusteringmigrationsql serverstoragevmware

My storage team wants to move a SQL cluster (2 node VM) from an old data store to Storage vMotion . What are the precautions I can take before this exercise is performed? I am planning to take database snapshots before the exercise and then shutdown the cluster and databases. The RDM's will be reconnected once the VM's have been moved to the new datastore. Are there any other best practices which I can follow before this process? Please advice.

Best Answer

I would:

  • Run DBCC CHECKDB on all databases prior to the move to ensure no consistency errors.
  • Take full SQL Server Backups of all user and system databases. Use native backup or your preferred third party tool.
  • When taking the backup, ensure it is verified.
  • Run DBCC CHECKDB on all databases post the move to ensure no consistency errors.
Related Question