sql-lover (11/13/2012)
Hi,I am working on the design of a MS-SQL 2012 failover cluster, running on top of Windows 2008. I am assuming mount point's behavior is similar between Denali and SQL 2008, as I will be using Windows 2008 anyway, but wanted to validate.
Here's the suggested disk layout:
D:\MSSQL\MSSQL10_50.I01\MSSQL
D:\MSSQL\MSSQL10_50.I01\MSSQL\Data
D:\MSSQL\MSSQL10_50.I01\MSSQL\Logs
D:\MSSQL\MSSQL10_50.I01\MSSQL\Backups
Each will be on a different LUN ... where the 1st one, will be for the binaries, next one Data, next one Logs, etc.
Do I have to create to specify a subdirectory under any of those, to avoid Cluster or permissions issues? For instance, when running the MS-SQL setup, do I have to create a sub-directory like this?
D:\MSSQL\MSSQL10_50.I01\MSSQL\Binaries
Or just specify this path: D:\MSSQL\MSSQL10_50.I01\MSSQL ??? ... so binaries will go there and setup will continue???
A similar question I think applies for Data, Log and backups ...
Also, this will be a two node Cluster only, with the possibility of one more SQL fail-over instance, using existing two nodes or servers. Should I really worry about Mount Points or go for a more simple approach, with drive letters?
Thanks in advance,
It seems to me that you are confusing mount points. Read my article at this link[/url] for more info on mount points.
Taking your scenario above you would first have a root drive, about 100MB in size or even smaller if possible. The root drive would be assigned a drive letter D:
Under this drive you create the folder structure below
D:\MSSQL\MSSQL10_50.I01\MSSQL
Under the MSSQL folder you create any folders that will be used to mount the NTFS volumes. Folders created would be
D:\MSSQL\MSSQL10_50.I01\MSSQL\Data
D:\MSSQL\MSSQL10_50.I01\MSSQL\Logs
D:\MSSQL\MSSQL10_50.I01\MSSQL\Backups
D:\MSSQL\MSSQL10_50.I01\MSSQL\Binaries
The 4 new volumes are then mounted under these folders. Once the volumes are mounted you must create a subfolder under each to facilitate the granting of NTFS permissions. It's all in my article linked above, post back if you're still stuck after reading that.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉