SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Help moving SQL instance folder structure from one SAN to another (cluster environment)


Help moving SQL instance folder structure from one SAN to another (cluster environment)

Author
Message
Keopx
Keopx
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 147
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 (MSmile to another (NSmile, so we're able to decomission the current SAN.

-Current folder structure----------------

Disk M: (current SAN drive)
...|-DATA
......|-all the user databases files
...|-MSSQL10_50.INSTANCE_A
......|-MSSQL
..........|-Backup
..........|-DATA
.............|-all system databases files (master, model, msdb)
..........|-FTData
..........|-JOBS
..........|-Log
..........|-repldata

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.
Minaz Amin
Minaz Amin
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1166 Visits: 1750
Create luns and vloume of the new san disk then try to move the database files and other dependecy one by one to the new san disk. Once done with it then remove the old san disk.

Found one similar discussion please check it http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/9e2503f7-1c8c-425a-87fb-b03aa0ece231

"More Green More Oxygen !! Plant a tree today"
Keopx
Keopx
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 147
Hello, Minaz... thank you for your quick reply. I checked the link you provided and the problem exposed there is aparently the same as ours, and the solution steps mentioned are more or less (if not the same) what I had thought could be done. We're going to set a small environment so we can test if it works.

Thanks again for taking time to answer!
Minaz Amin
Minaz Amin
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1166 Visits: 1750
hmm. Is it possible to have two sans attached to box and configure it so the cluster also could see it. The second san will be the replica of 1st one only we need the sql cluster to recognize and get connect .

Once done with your testing please share this is will be good learning for all of us.:-)

"More Green More Oxygen !! Plant a tree today"
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search