PrepAway - Latest Free Exam Questions & Answers

You need to configure mirroring between two servers in high-performance mode

You administer a Microsoft SQL Server 2008 R2 instance.
You need to configure mirroring between two servers in high-performance mode.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
• Create mirroring endpoints on both partner servers.
• Use Microsoft SQL Server Management Studio on both partner servers to select the High
Performance option, and start mirroring.

B.
• Create mirroring endpoints on both partner servers.
• On the principal server, use the ALTER DATABASE statement along with the PARTNER
SAFETY OFF clause.

C.
• Create mirroring endpoints on both partner servers.
• Execute the following stored procedure:
Sp_configure ‘Lightweight Pooling’, 1

D.
• Create mirroring endpoints on both partner servers.
• Use the ALTER ENDPOINT statement along with the ENCRYPTION=DISABLED clause.


Leave a Reply