70-465 · Question #5
Drag and Drop Question You have two servers named SQL1 and SQL2 that have SQL Server 2012 installed. SQL1 contains a database that is mirrored asynchronously to SQL2. The database contents are…
The correct answer is Fail over.; Upgrade SQL1.; Upgrade SQL2.; Establish a mirror.; Break the mirror. The correct sequence minimizes downtime by first failing over to SQL2 (making it the principal), then upgrading the now-mirror SQL1 while SQL2 serves users, then upgrading SQL2, re-establishing the mirror, and finally breaking the mirror once complete. This rolling upgrade…
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- Fail over.
- Upgrade SQL1.
- Upgrade SQL2.
- Establish a mirror.
- Break the mirror.
Explanation
The correct sequence minimizes downtime by first failing over to SQL2 (making it the principal), then upgrading the now-mirror SQL1 while SQL2 serves users, then upgrading SQL2, re-establishing the mirror, and finally breaking the mirror once complete. This rolling upgrade approach ensures the database remains available throughout most of the process, since SQL Server 2012 and SQL Server 2014 can participate in database mirroring during a mixed-version transition window. 'Fail back' is unnecessary because after upgrading both servers and establishing the mirror, you simply break it rather than failing back to SQL1 as principal.
Topics
Community Discussion
No community discussion yet for this question.