Wednesday, March 21, 2012

Move TempDB Database off of the SAN

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 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.
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

No comments:

Post a Comment