Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Availability Groups and DR (2012)
 AG Failover Question

Author  Topic 

morrisos
Starting Member

10 Posts

Posted - 2015-01-14 : 15:22:28
Setup- 2-node AG with a synchronous-commit replica.

When an unplanned failover occurs will existing connections be disrupted? I know data loss shouldn't occur but will users (connections) experience any down time? Will running processes be disrupted and have to be restarted?

Thanks,
Morrisos

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-14 : 15:33:27
Yes existing connections will be disrupted since the group is moving to another SQL instance. Also any queries that are currently running are killed and rolled back.

Downtime should be just a few seconds. Whether or not you need to restart your processes is dependent on the applications. Lots of applications are coded to retry.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -