Run out of Drive Letters, and mount point in SQL server 2008
Posted on 2011-02-10
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.