Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-02-10
6
Medium Priority
?
1,232 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 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

722 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