DRAG DROP
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
updated once a month.
You need to upgrade the database to SQL Server 2014. The solution must minimize
downtime.
Which upgrade steps should you recommend?
To answer, move the appropriate actions from the list of actions to the answer area and
arrange them in the correct order.
Answer: See the explanation.
Explanation:
Box 1: Fail over.
Box 2: Upgrade SQL1.
Box 3: Upgrade SQL2.
Box 4: Establish a mirror.Note:
* To perform the rolling upgrade
step 1: For each mirroring session whose mirror server instance has just been upgraded,
wait for the session to synchronize. Then, connect to the principal server instance, and
manually fail over the session.
Step 2: Upgrade each server instance that is now the mirror server in all mirroring sessions
in which it is a partner.
Step 3: Resume the mirroring session.
* When upgrading server instances to SQL Server 2014, you can reduce downtime for each
mirrored database to only a single manual failover by performing a sequential upgrade,
known as a rolling upgrade. A rolling upgrade is a multi-stage process that in its simplest
form involves upgrading the server instance that is currently acting as the mirror server in a
mirroring session, then manually failing over the mirrored database, upgrading the former
principal server, and resuming mirroring
Reference: Minimize Downtime for Mirrored Databases When Upgrading Server Instances