|
Home > Archive > MS SQL Server Clustering > August 2005 > SQL Server Software on cluster: local drive other than C:?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server Software on cluster: local drive other than C:?
|
|
|
| I'm trying to build a new cluster with SQL Server 2K Enterprise on
Windows 2003 server. When I run the install, I tell it to put the
program files on the D: (local) drive and the data/log files on shared
drives. However, after the installation is complete, almost all the
files go in the C: drive in \program files\Microsoft SQL Server, rather
than the D: drive (it does create a few files on D:). We've experienced
this on more than one server build.
Anyone know any way around this?
Post answers publicly, please, or email to
steven. wechsler(at)mtvstaff
.com (the posting email address is hosed).
Thanks,
Steve
| |
| Mike Epprecht \(SQL MVP\) 2005-08-15, 8:24 pm |
| Hi
What was installed on the C Drive?
Quite often, people forget that the client components installation path is
also configurable in the setup and only pay attention to the server path.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve" <swechsler@bigfoot.com> wrote in message
news:1124133504.295776.13680@f14g2000cwb.googlegroups.com...
> I'm trying to build a new cluster with SQL Server 2K Enterprise on
> Windows 2003 server. When I run the install, I tell it to put the
> program files on the D: (local) drive and the data/log files on shared
> drives. However, after the installation is complete, almost all the
> files go in the C: drive in \program files\Microsoft SQL Server, rather
> than the D: drive (it does create a few files on D:). We've experienced
> this on more than one server build.
>
> Anyone know any way around this?
>
> Post answers publicly, please, or email to
> steven. wechsler(at)mtvstaff
.com (the posting email address is hosed).
>
> Thanks,
>
> Steve
>
| |
| Simon Hayes 2005-08-16, 3:23 am |
| I don't know much about clustering myself, however this KB article
notes that in SQL 2000, only databases are failed over, not binaries,
so in order for setup to install the binaries, "you must ensure that
each node has a local drive letter in common with all the other nodes
in the cluster". Is it possible that only some nodes have a D: drive?
http://support.microsoft.com/defaul...kb;en-us;243218
In any case, it would probably be worth giving Microsoft a call - I
guess that if you have the requirement and the resources to implement
clustering, then the cost of a support call is negligible (if you don't
already have a general support agreement). And if the issue is caused
by a bug in the product, then it's free anyway.
Simon
|
|
|
|
|