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

Mount points vs. drive letters.... Expand / Collapse
Author
Message
Posted Thursday, October 26, 2006 7:34 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:17 PM
Points: 2,644, Visits: 809
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
Post #318585
Posted Friday, October 27, 2006 1:22 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 522, Visits: 2,012

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.

 

Post #318608
Posted Friday, October 27, 2006 1:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:34 PM
Points: 6,997, Visits: 8,409

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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

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


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #318611
Posted Sunday, October 29, 2006 12:14 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:17 PM
Points: 2,644, Visits: 809
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
Post #318901
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse