Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Exam 70-764 topic 1 question 136 discussion

Actual exam question from Microsoft's 70-764

Question #: 136
Topic #: 1

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

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

by RohitM at Sept. 23, 2019, 10:50 p.m.

Comments

Submit Cancel

msamm

Highly Voted 5 years, 8 months ago

Agree with RohitM the steps in order would be : Upgrade SQL2 Failover Upgrade SQL1 Failback Reference : https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/upgrading-mirrored-instances?view=sql-server-2017

upvoted 9 times

KC

4 years, 9 months ago

I'll jump in and say that I agree also. This is the correct answer.

upvoted 1 times

...

huzein

4 years, 7 months ago

I agree. https://techcommunity.microsoft.com/t5/datacat/minimize-downtime-with-db-mirroring/ba-p/305003

upvoted 1 times

...

RohitM

Highly Voted 5 years, 8 months ago

answer is wrong for this question. correct answer would be upgrade SQL2 failover upgrade SQL1 failback

upvoted 8 times

...

norbert1

Most Recent 4 years, 9 months ago

is right upgrading sql 2 really minimizing downtime..in comparison to fail over??

upvoted 1 times

...

witty

4 years, 11 months ago

If you read the question it states this is an Async connection and the data is only updated once per month. This is why it is likely easier to simply break the mirror, run the updates and then re-establish. If it was an Synchronous connection I would agree with you but I think a rolling upgrade would break the mirror anyway on a async connection.

upvoted 3 times

huzein

4 years, 7 months ago

Yes, but SQL1 is mirrored to SQL2, means that SQL1 is the principal and SQL2 the mirror, means that SQL1 is accessible and SQL2 not. So you have to first upgrade SQL2 and then failover and then switch to SQL1 to upgrade, else users will experience a downtime because SQL1 is the principal.

upvoted 1 times

...

V_karag

5 years ago

https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/upgrading-mirrored-instances?view=sql-server-ver15

upvoted 1 times

...

TheSwedishGuy

5 years, 4 months ago

100% the solution is wrong on this question. You should do as previously discussed. Upgrade SQL2 Failover Upgrade SQL1 Failback

upvoted 1 times

...