Mount points vs. drive letters....
-
What are peoples' opinions of mounting drives as folders (i.e. mount points) as opposed to assigning drive letters? Anyone encounter any problems?
Not that I expect that anyone would run out of drive letters, but just a thought that popped into my head.
Scott DuncanMARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare -
I would be curious to know how you do these mount points. Is something you do in SQL Server?
In any case, the last time I had to deal with a similar problem was when an ASP page executed a query and had to do a save of the ADO result set to a share which required a user and password to access. I never found a way to access this share without mapping it to a drive using WScript.Network's MapNetworkDrive method. But before doing so, the code would scan all existing mapped network drives to see if it's already mapped, etc. etc.
-
...Not that I expect that anyone would run out of drive letters...
- consider a cluster-node with a couple of instances topology driv1-data1 drive2-data2 drive3-log drive4-backup .... You'll run out of driveletters soon enough
- I've mounted the backupvolume in a folder of the logdrive for some of our instances.
Just to keep a reminder, this mounted-directory is named MOUNTED_bu,
so it leaves a trace everywhere it is being used or may be used.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Funny you should mention a cluster with multiple instances. That's something I've been tasked with investigating as part of a consolidation project, hence why it popped into my head.
Good point re: naming the folder.
Michael:
No, it's something you do in the OS. In Disk Mgmt, instead of assigning a drive letter to a drive, you can mount it to a folder on an existing drive. So you see an extra folder on your C: drive, say, rather than seeing a D: drive. Note: only works with NTFS. Search for "mounting partitions" in Windows help. Works in Win2K & Win2K3.
Scott DuncanMARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply