Solved

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

Posted on 2011-02-10
6
1,229 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

A safe way to clean winsxs folder from your windows server 2008 R2 editions
I have a large data set and a SSIS package. How can I load this file in multi threading?
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
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.

632 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