Which upgrade steps should you recommend?

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.

View Answer

Answer:

Explanation:

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.

References: Minimize Downtime for Mirrored Databases When Upgrading Server Instances