1

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.

Improve this question
1
  • Snapshots are not backups. Take full backups of the databases using the native BACKUP method, just in case.
    – Randolph West
    Commented Oct 21, 2016 at 21:54

1 Answer 1

Reset to default
1

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.
Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.