Run out of alphabets

When you set up say 3 active and 1 passive multi instance cluster and
especially if any one instance uses say 10 alphabets, how do you configure
the cluster then ? Can you use something other than alphabets for your
resources ? This would be tied to a SAN too...
First investigate mount-points on cluster service :
http://support.microsoft.com/kb/280297
Then investigate mount-points for SQL :
http://support.microsoft.com/kb/819546/
HTH,
_Edwin.
"Hassan" <hassan@.hotmail.com> wrote in message
news:uM0CygnRHHA.3812@.TK2MSFTNGP06.phx.gbl...
> When you set up say 3 active and 1 passive multi instance cluster and
> especially if any one instance uses say 10 alphabets, how do you configure
> the cluster then ? Can you use something other than alphabets for your
> resources ? This would be tied to a SAN too...
>
|||"Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
news:uuYXgOqRHHA.1228@.TK2MSFTNGP06.phx.gbl...
> First investigate mount-points on cluster service :
> http://support.microsoft.com/kb/280297
> Then investigate mount-points for SQL :
> http://support.microsoft.com/kb/819546/
and then redesign you cluster to make sure you have enough drive letters...
I have seen and heard bad things about using mount points both in Exchange
and in SQL.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Denver starting Feb 12th
NYC starting Feb 19th
London starting March 6th
|||Mount points seem a lot more stable in SQL 2005, at least from what I have
seen and heard.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Russ Kaufmann [MVP]" <russ@.clusterhelp.com> wrote in message
news:ue$7SNuRHHA.2256@.TK2MSFTNGP02.phx.gbl...
> "Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
> news:uuYXgOqRHHA.1228@.TK2MSFTNGP06.phx.gbl...
> and then redesign you cluster to make sure you have enough drive
> letters...
> I have seen and heard bad things about using mount points both in Exchange
> and in SQL.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Denver starting Feb 12th
> NYC starting Feb 19th
> London starting March 6th
>
|||I have tested using mounted volumes in SQL2005 quite extensively. Apart from
the fact that they forgot to require the dependency of SQL Server on a
mounted volume, I don't see any serious issue with supporting mounted volumes
with SQL2005 in a cluster.
Linchi
"Russ Kaufmann [MVP]" wrote:

> "Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
> news:uuYXgOqRHHA.1228@.TK2MSFTNGP06.phx.gbl...
> and then redesign you cluster to make sure you have enough drive letters...
> I have seen and heard bad things about using mount points both in Exchange
> and in SQL.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Denver starting Feb 12th
> NYC starting Feb 19th
> London starting March 6th
>
>
|||I must admit I have seen bad things with mountpoints as well, however I have
yet to find a case where it is not related to bad configuration, and
predominantly the setup of dependencies.
rgds,
Edwin.
"Russ Kaufmann [MVP]" <russ@.clusterhelp.com> wrote in message
news:ue$7SNuRHHA.2256@.TK2MSFTNGP02.phx.gbl...
> "Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
> news:uuYXgOqRHHA.1228@.TK2MSFTNGP06.phx.gbl...
> and then redesign you cluster to make sure you have enough drive
letters...
> I have seen and heard bad things about using mount points both in Exchange
> and in SQL.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Denver starting Feb 12th
> NYC starting Feb 19th
> London starting March 6th
>
|||If you are running SS2K or a mix of SS2K and SS2K5, then you have found the
limitation with multi-instancing and clusters: SQL Server 2000 does not
support drive mount points, at all, not even for SS2K5 on the same cluster.
http://support.microsoft.com/kb/819546/en-us
If you are only running SS2K5, then mount points are supported. You would
use 1 drive letter for the base drive, but then use mount points for the
remainder. You would need to create one lettered drive for each resource
group/SQL Server instance.
http://support.microsoft.com/kb/280297/
Sincerely,
Anthony Thomas

"Hassan" <hassan@.hotmail.com> wrote in message
news:uM0CygnRHHA.3812@.TK2MSFTNGP06.phx.gbl...
> When you set up say 3 active and 1 passive multi instance cluster and
> especially if any one instance uses say 10 alphabets, how do you configure
> the cluster then ? Can you use something other than alphabets for your
> resources ? This would be tied to a SAN too...
>