Solved

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

Posted on 2011-02-10
6
1,225 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 500 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

791 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