locked
How to move SQL server databases from one storage drive to another RRS feed

  • Question

  • Hi,

    i have SQL server 2008R2 in Cluster (two nodes) and all databases are on shared storage drive e.g "S" from a SAN. Now due to some reasons we are replacing SAN with new one. so i have to move all DBs, etc to new storage. please guide how to do?

    Regards

    Sajid

    Wednesday, February 10, 2016 4:52 AM

Answers

  • Refer first 

    https://gallery.technet.microsoft.com/SAN-Migration-step-for-SQL-d66dea19

    https://msdn.microsoft.com/en-us/library/ms187858.aspx?f=255&MSPPError=-2147217396

    For master database

    https://msdn.microsoft.com/en-us/library/ms345408%28SQL.90%29.aspx?f=255&MSPPError=-2147217396


    Please click Mark As Answer if my post helped.



    Wednesday, February 10, 2016 5:33 AM