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.
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
AG Failover Question