We are running a database on a stretched 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 using SQL 2005 on Windows 2008.