Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Run out of Drive Letters, and mount point in SQL server 2008

Posted on 2011-02-10
6
Medium Priority
?
1,235 Views
Last Modified: 2012-05-11
Currently we are running three SQL2008  server instances in a two nodes Win 2008 cluster.  We are using IBM snapmanager to do the DB backup.  However, we found that the backup job sometimes failed if it backed up more than 30 databases at a time.  We finally need to separate DB into different luns within the same DB instance.  It will run into trouble when we have more and more databases.  It will run out of Windows drive letters when put additional databases into additional luns.  We think of using mount point on the SQL servers (thus there is no limit on the Windows drive letters).  I have never made use of mount point.  Can any one provide info on how to set up mount up on SQL server 2008?

Thanks you very much.
0
Comment
Question by:ICKW
  • 3
  • 2
6 Comments
 
LVL 70

Expert Comment

by:KCTS
ID: 34863875
Mount points are set up in Windows - not in SQL server see http://technet.microsoft.com/en-us/library/cc783258(WS.10).aspx
0
 
LVL 31

Accepted Solution

by:
Justin Owens earned 2000 total points
ID: 34863968
SQL uses mounted drives, whether by mount points or by drive letter.  It is controlled by the OS, not by the SQL program.

To set up mounted volumes in Windows 2003:

http://support.microsoft.com/kb/280297

SQL support for mounted volumes:

http://support.microsoft.com/kb/819546

DrUltima
0
 
LVL 31

Expert Comment

by:Justin Owens
ID: 34863980
Sorry, Brian.  Refresh got me. -Justin
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 

Author Comment

by:ICKW
ID: 34867723
Thanks for the info.  If it's a two-nodes  Windows cluster, need to do the mount point on both nodes?
0
 

Author Comment

by:ICKW
ID: 34940862
Thanks for the info.  If it's a two-nodes  Windows cluster, need to do the mount point on both nodes?
0
 
LVL 31

Expert Comment

by:Justin Owens
ID: 34942957
Yes.  The cluster's nodes need to be the same.
0

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question