Link to home
Start Free TrialLog in
Avatar of ICKW
ICKW

asked on

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.
Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

Mount points are set up in Windows - not in SQL server see http://technet.microsoft.com/en-us/library/cc783258(WS.10).aspx
ASKER CERTIFIED SOLUTION
Avatar of Justin Owens
Justin Owens
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry, Brian.  Refresh got me. -Justin
Avatar of ICKW
ICKW

ASKER

Thanks for the info.  If it's a two-nodes  Windows cluster, need to do the mount point on both nodes?
Avatar of ICKW

ASKER

Thanks for the info.  If it's a two-nodes  Windows cluster, need to do the mount point on both nodes?
Yes.  The cluster's nodes need to be the same.