ms sql cluster: should i and how to place tempdb on local drive

Hi all
we are about to set up database on sql server cluster. Up to this point we
had set up ms sql cluster using vm.
My intention was to set up tempdb on local c drive. It turned out, that we
could not mount c drive at all and only drives which we mounted were drives
defined for cluster.
1. Do we miss something? Does clustered software allows to mount local
drives along with cluster defined drives?
2. If yes, do you recommend to use local drive for tempdb.
Thank you for your respond.
You can only place SQL data files on clustered drives where SQL is dependent
on the particular disk resource. This includes data files for tempdb.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
> Hi all
> we are about to set up database on sql server cluster. Up to this point we
> had set up ms sql cluster using vm.
> My intention was to set up tempdb on local c drive. It turned out, that we
> could not mount c drive at all and only drives which we mounted were
> drives
> defined for cluster.
> 1. Do we miss something? Does clustered software allows to mount local
> drives along with cluster defined drives?
> 2. If yes, do you recommend to use local drive for tempdb.
> Thank you for your respond.
|||Hi all
I would like to remark myself regarding my post below.
C drive is visable to cluster pc but...
it's not visable to sql server.
When you create new db either using tsql or windows inerface, 1 one produce
error complaining about not visable drive.
Windows interface does not show c drive as one generaly available for
database creation.
"Gene." wrote:

> Hi all
> we are about to set up database on sql server cluster. Up to this point we
> had set up ms sql cluster using vm.
> My intention was to set up tempdb on local c drive. It turned out, that we
> could not mount c drive at all and only drives which we mounted were drives
> defined for cluster.
> 1. Do we miss something? Does clustered software allows to mount local
> drives along with cluster defined drives?
> 2. If yes, do you recommend to use local drive for tempdb.
> Thank you for your respond.
|||Geoff
Do you mind if i ask you:
We can not do it because cluster does not have c drive defined to it (and
likely can not have c drive defined to it)?
Gene.
"Geoff N. Hiten" wrote:

> You can only place SQL data files on clustered drives where SQL is dependent
> on the particular disk resource. This includes data files for tempdb.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
>
|||C: is local to each node and cannot be defined as a cluster resource even
when it exists on all nodes. You cannot place tempdb for a cluster on local
disks.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:C7F5E403-A592-452C-B5C0-7DCC7D1B437B@.microsoft.com...[vbcol=seagreen]
> Geoff
> Do you mind if i ask you:
> We can not do it because cluster does not have c drive defined to it (and
> likely can not have c drive defined to it)?
> Gene.
> "Geoff N. Hiten" wrote:
|||Thank you Geoff. now I understand.
"Geoff N. Hiten" wrote:

> C: is local to each node and cannot be defined as a cluster resource even
> when it exists on all nodes. You cannot place tempdb for a cluster on local
> disks.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:C7F5E403-A592-452C-B5C0-7DCC7D1B437B@.microsoft.com...
>