exam questions

Exam 70-465 All Questions

View all questions & answers for the 70-465 exam

Exam 70-465 topic 1 question 29 discussion

Actual exam question from Microsoft's 70-465
Question #: 29
Topic #: 1
[All 70-465 Questions]

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:

Show Suggested Answer Hide Answer
Suggested Answer:
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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
prprgndr
4 years, 4 months ago
I believe the order should be: 1> Upgrade SQL2. 2> Fail over. 3> Upgrade SQL1. 4> Establish a mirror. (with the newly upgraded SQL1) Reference: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/upgrading-mirrored-instances?view=sql-server-ver15#:~:text=To%20minimize%20downtime%2C%20we%20recommend,in%20the%20rolling%20upgrade%20process.
upvoted 1 times
...
Rc2229
5 years, 2 months ago
1. Failover 2. Upgrade Sql1 3. Upgrade Sql2 4. Establish a mirror
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago