tempdb utilized as Failover occurs?
Let's say there are two servers, server 1 is primary and server 2 is secondary. Suddenly, Failover happens, so, how does
tempdb behave during this situation?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Tempdb doesn't move when an AG failover occurs. Each replica is its own standalone instance. Each has its own tempdb. Queries will break during the failover. Once the application reconnects after the failover is complete and crash recovery is also complete, the queries can then run on the other instance where it has its own tempdb.
A Failover Cluster Instance fails over at the instance level, so tempdb is affected. But not for Availability Groups.