SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Mount points vs. drive letters....


Mount points vs. drive letters....

Author
Message
thecosmictrickster@gmail.com
thecosmictrickster@gmail.com
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5978 Visits: 940
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 Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

Michael Meierruth
Michael Meierruth
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3668 Visits: 2522

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.


ALZDBA
ALZDBA
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47769 Visits: 9066

...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


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


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
thecosmictrickster@gmail.com
thecosmictrickster@gmail.com
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5978 Visits: 940
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 Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

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