I'm not having issues with the actual mirroring part, but because of the use of temporary tables, IIS is throwing a bit of a wobbler if a failover occurs (I'm still testing a few things, so it's me causing the failover).
Is it possible (or even a good idea) to mirror
tempdb? Or should I just accept that some people might get kicked out if the principal database is not accessible for any reason.
I'm using ASPState so that the two web servers (behind a load balancer that enables sticky sessions) can both get to the same session data.