We have a web based applicatoin that uses SQL based session information storage in the TEMPDB. This is a .NET applicaiton. After initial testing, we found out that the TEMPDB is "recreated" after a failover by default and the session informattion is no longer available becuse the TEMPDB has been recerated.
What is the accepted way to fix this? Can the tempdb be set not to be recreated on SQL Engine startup?
IIS (.net) creates stored procedures that use the TEMPDB by default to write / read session information, can this be reconfigured to use a different database of out choosing?
The main point is that we would like to keep a session alive during / after a cluster failover event.
Any help would be appreciated.