January 23, 2014 at 5:52 am
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.
January 23, 2014 at 7:29 am
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" 😉
January 23, 2014 at 10:41 am
I see all mount points as Drive letters in the Windows Disk Management
February 3, 2014 at 7:29 pm
Techies,
Any help on this question please..?
February 4, 2014 at 4:22 am
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" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply