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

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.
ICKWAsked:
Who is Participating?
 
Justin OwensConnect With a Mentor ITIL Problem ManagerCommented:
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
 
Brian PiercePhotographerCommented:
Mount points are set up in Windows - not in SQL server see http://technet.microsoft.com/en-us/library/cc783258(WS.10).aspx
0
 
Justin OwensITIL Problem ManagerCommented:
Sorry, Brian.  Refresh got me. -Justin
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
ICKWAuthor Commented:
Thanks for the info.  If it's a two-nodes  Windows cluster, need to do the mount point on both nodes?
0
 
ICKWAuthor Commented:
Thanks for the info.  If it's a two-nodes  Windows cluster, need to do the mount point on both nodes?
0
 
Justin OwensITIL Problem ManagerCommented:
Yes.  The cluster's nodes need to be the same.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.