DRAG DROP
You administer three Microsoft SQL Server 2008 R2 instances.
Database mirroring is configured in High-Safety mode with Automatic Failover between the following three
servers:
· SQL1 is the Principal server.
· SQL2 is the mirror server.
· SQL3 is the witness server.
You need to upgrade SQL1 and SQL2 to SQL Server 2012. You need to ensure that downtime is minimized
during the upgrade.
Which six actions should you perform in sequence? (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:
Which six actions should you perform in sequence?
DRAG DROP
You administer three Microsoft SQL Server 2008 R2 instances.
Database mirroring is configured in High-Safety mode with Automatic Failover between the following three
servers:
· SQL1 is the Principal server.
· SQL2 is the mirror server.
· SQL3 is the witness server.
You need to upgrade SQL1 and SQL2 to SQL Server 2012. You need to ensure that downtime is minimized
during the upgrade.
Which six actions should you perform in sequence? (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:
http://technet.microsoft.com/en-us/library/bb677181.aspx
My guess is
1) Remove SQL3 from …
2) Upgrade SQL2…
3) Manual failover … from SQL1 to SQL2
4) Upgrade SQL1…
5) Manual failover … from SQL2 to SQL1
6) Add SQL3 back …