|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ms sql cluster: should i and how to place tempdb on local driveHi 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. -- Show quoteGeoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Gene." <G***@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. 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. Show quote "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." <G***@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. > > 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. -- Show quoteGeoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Gene." <G***@discussions.microsoft.com> wrote in message news:C7F5E403-A592-452C-B5C0-7DCC7D1B437B@microsoft.com... > 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." <G***@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. >> >> Thank you Geoff. now I understand.
Show quote "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." <G***@discussions.microsoft.com> wrote in message > news:C7F5E403-A592-452C-B5C0-7DCC7D1B437B@microsoft.com... > > 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." <G***@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. Show quote "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.  |
|||||||||||||||||||||||
Other interesting topics