Move SQL server database storage

Question

Our organization has purchased new SAN for the SQL database. The SQL server is configured as a two nodes failover cluster where one node is active and the other is passive and databases are stored on the current running SAN.

Kindly assist in how we can change our SQL databases from the current SAN to the new SAN without any downtime.

Thanks in advance.

Answer 1

Hi @Muhammad Hammad ,

If you want to without any downtime, one way you may can try is to contact your SAN vendor, they will do cloning of the disks without downtime, all they have to do is to remove existing old SAN luns and add new SAN luns to your server, other option is to take a backup of existing database and restore

https://social.msdn.microsoft.com/Forums/vstudio/en-US/3bb22c95-5054-4611-a7e4-936c0381a4f3/sql-database-migration-on-new-storage?forum=sqlservermigration

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Muhammad Hammad

If your storage vendor has no magic tools available, this won't happen without downtime.

Even changing the active LUNs on that machine will need some downtime... but the easiest way, and with a minimum amount of downtime, would be:

• set up a synch job between old and new storage
• synch all relevant disks
• prepare the cluster and the storage for new disks
• downtime start
• lastly, remove the old storage
• attach that new storage
• restart SQL Ressource Group
• downtime ends

I hope my answer is helpful to you,

Your
Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!