You have two servers named SQL1 and SQL2 that have SQL Server 2008 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 2012. 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.
Build List and Reorder:
Which upgrade steps should you recommend?
You have two servers named SQL1 and SQL2 that have SQL Server 2008 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 2012. 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.
Build List and Reorder:
Should SQL2 be upgraded first since SQL1 is primary?
It should be
https://technet.microsoft.com/en-us/library/bb677181(v=sql.110).aspx
1. Upgrade SQL 2
2. Fail over
3. Upgrade SQL 1