At the office, we have a 2-nodes cluster configuration running a SQL Server instance on each node (active/active). We need to move all of the data in the current SAN drive (M
to another (N
, so we're able to decomission the current SAN.
-Current folder structure----------------
Disk M: (current SAN drive)
......|-all the user databases files
.............|-all system databases files (master, model, msdb)
Disk N: (new SAN drive)
We had scheduled a day to make the change on one of the nodes, but I came to notice that the SQL Server instance folder structure (MSSQL10_50.INSTANCE_A\MSSQL and its subfolders; Backup, DATA, JOBS, Log, etc) which contains the instance system databases currently resides in the drive we want to remove... so I want to know... is there a way to make the move of the whole folder structure to the new SAN without removing the cluster configuration and create it all over again?.
First idea that came to my mind (a naive one perhaps) was that if we stop the SQL Server instance, copy to the new SAN all of the user databases files and the SQL Server instance folder structure containing the system databases and other files, and once the copy finishes, change the new SAN drive letter to that of the old SAN drive, so once that the SQL Server instance starts, it would read the files from the "same path" as if nothing had been changed. I don't really know if this could be performed without causing the cluster to malfunction or something going wrong... i'm not very experienced in the field of cluster administration, this is the first time i've got to deal with an issue that affects such an environment. I hope someone would give me some clue or piece of advice about what we want to do in our current scenario.
Help is much appreciated, thanks in advance.