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.
Select and Place:

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.
Select and Place:

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
Minimize Downtime for Mirrored Databases When Upgrading Server Instances



Leave a Reply 1

Your email address will not be published. Required fields are marked *