Interview Questions
1. What is “Failover” in Always ON?
Within the context of a session between the primary replica and a secondary replica, the primary and secondary roles are
potentially interchangeable in a process known as failover. During a failover the target secondary replica transitions to the
primary role, becoming the new primary replica. The new primary replica brings its databases online as the primary databases,
and client applications can connect to them. When the former primary replica is available, it transitions to the secondary role,
becoming a secondary replica. The former primary databases become secondary databases and data synchronization resumes.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment