Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Convert Drive Letters to Mount Points in SQL Cluster Expand / Collapse
Author
Message
Posted Thursday, January 23, 2014 5:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:51 AM
Points: 11, Visits: 223
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.
Post #1534026
Posted Thursday, January 23, 2014 7:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 6,350, Visits: 13,674
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"
Post #1534071
Posted Thursday, January 23, 2014 10:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:51 AM
Points: 11, Visits: 223
I see all mount points as Drive letters in the Windows Disk Management
Post #1534191
Posted Monday, February 3, 2014 7:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:51 AM
Points: 11, Visits: 223
Techies,

Any help on this question please..?
Post #1537586
Posted Tuesday, February 4, 2014 4:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 6,350, Visits: 13,674
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"
Post #1537682
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse