Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Convert Drive Letters to Mount Points in SQL Cluster


Convert Drive Letters to Mount Points in SQL Cluster

Author
Message
harikumar.mindi
harikumar.mindi
SSC Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 Visits: 527
Hi Techies,

I need some really urgent help help here. We use a single drive letter and use 4 mount points on it to separate the DATA, TLOG, TEMPDB and BACKUP drives. This we use it on Windows Server 2008 R2 with SQL 2008 installations on a 2-node cluster environment.
Recently we had to create one more instance on this cluster. There were 4 mount points created by our storage team and the technician who performed the installation did the following.
>>Added 4 mount points to the cluster resource group.
>>During the SQL cluster installation it discovered 5 drives in total (which includes the actual drive letter and 4 mount points)
>>He completed the remaining installation

After completing the installation, we noticed that they were not showing under the driver letter but instead 4 drive letters were created. I assume this could be because he did not add dependency of the mount points to the drive letter assigned.

Currently the instance is active but we need to convert these drive letters to mount points and should be added under a single drive letter which was originally intended.

Appreciate any help on this.
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
edit the volume in windows disk management, do you see a drive letter and a volume mount point name?

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
harikumar.mindi
harikumar.mindi
SSC Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 Visits: 527
I see all mount points as Drive letters in the Windows Disk Management
harikumar.mindi
harikumar.mindi
SSC Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 Visits: 527
Techies,

Any help on this question please..?
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
Moving the user and system database files to different locations can be done. It depends on your amount of experience with SQL Server. The fact that the mounted volumes are incorrectly named adds to the confusion for you.

I may be easier for you to uninstall and then reinstall once the volumes have been corrected.

Typically what i have seen is that the volumes still have the mounted vol path assigned to them, but when adding the storage to the cluster a drive letter gets assigned too. By removing the assigned drive letters and leaving just the mount folder assignments you should be able to get the vols reconfigured easily enough this just then leaves moving the database files. Of course the instance is offline while you do all this.

So, the million dollar question is "how comfortable do you feel"?
Either that or pass back to the deployment team and have them reconfigure it ;-)

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
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