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.

1
  • Snapshots are not backups. Take full backups of the databases using the native BACKUP method, just in case. Oct 21, 2016 at 21:54

1 Answer 1

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.
0

Your Answer

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

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