You administer a Microsoft SQL Server 2008 R2 instance. Mirroring has been configured
between two servers.
You need to ensure that automatic failover will occur when the principal server fails
What should you do?
A.
• Create a witness server to monitor the mirroring session.
• On the principal server, use the ALTER DATABASE statement along with the SET
WITNESS clause.
B.
• Create a witness server to monitor the mirroring session.
• On both partner servers, use the ALTER DATABASE statement along with the SET
WITNESS clause.
C.
• Create a Microsoft SQL Server Integration Services package on the partner server to
monitor the principal server.
D.
• Implement Policy Based Management.
• Enable the Server Performance management facet.
Explanation: