RE: Tempdb on non clustered disk

Tech-Archive recommends: Fix windows errors by optimizing your registry

You could configure the SAN replication of the tempdb drive to be
asynchronous, if not already. In addition, some SAN replication allows a mode
that doesn't require acknowledgement from the other side (similar to what you
get with UDP as opposed to TCP). This gives you performance, but doesn't
guarantee data integrity. But then since tempdb is rebuilt on restart, you
don;t care either.

I tested this before and it works well with tempdb.

Linchi

"jan.devylder@xxxxxxxxx" wrote:

Hi,

We are running a database on a streched cluster with a SAN. The tempdb
is on a clustered disk and is replicated to the other site. This seems
completely wasted to me, since when after failover the database
restarts on the other site and recreates the tempdb.

When I search this forum, I find that it wouldn't be possible and that
someone had a message like this:

Only formatted files on which the
cluster resource of the server has a dependency can be used.
Server: Msg 5184, Level 16, State 1, Line 2

And of course a dependency is only possible on clustered resources.

Is there somebody who has found a solution for this? We are usning SQL
2005 on Windows 2008.

thanks,
Jan

.