January 9, 2008 at 4:28 am
Please don't laugh if that question seems stupid but...:blush:
Is it possible to use a local disk for tempdb in a failover cluster (2 nodes) configuration?
Since each database goes through the recovery phase in the event of a failover switch, it seems not to matter that the tempdb is not shared...
We are just trying to improve speed if it's easy (we use a SAN for our failover cluster).
Thanks
January 9, 2008 at 5:17 am
In the cluster environment you can't put tempdb on the local drive. If you will put the tempdb on local drive of node1 when the failover happen tempdb location on node1 won't be available to node2 and node2 will fail to start tempdb as it's unable to find tempdb location.
Hope this will clarify your doubts.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 9, 2008 at 5:26 am
What about if you create tempdb in the "same" location on both nodes...
For instance ona D:\TempDb folder?
The only thing that would get out of step is the actual size of tempdb if this is held in master.
January 9, 2008 at 5:38 am
It won't work. While failover occurs at that time tempdb is on node1 d:\Tempdb folder. But Tempdb on node2 will be created only when you will restart the sql server. Hence logically it's not possible. Node2 will still try to access the tempdb on node1 d:\Tempdb folder.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 9, 2008 at 5:41 am
Ok, got it!
Many thanks 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply