I have a system configured with Windows 2000 and SQL Server 2000
Clustering (active/passive). Both SQL Servers have a local E:\ drive
with the same directory structure. I would like to move the tempdb
off of the shared SAN and on to the E:\ drive. I don't foresee any
issues with this but wanted to know if anyone else has encountered
problems with this.

Conceivable it should work but would not be a supported configuration.

Rand
This posting is provided "as is" with no warranties and confers no rights.

If you would like to put tempdb on a different disk (for performance reasons)
you'd be better to create a new disk on a different disk pool on your SAN.
That way, you'd keep your support options open.

I am vaguely trying to do the same. But how do you plan to make your local
disk visible as a resource of the cluster ? If you cannot make it a
resource of the cluster, you cannot make it recognized...
I am trying to add it as a disk share resource, but it is not accepted by
SQL Server in cluster, even with trace flag 1807.

Did someone manage do do it ?

thanks in advance,
rudi