You administer a SQL Server 2008 instance.
You plan to design a high-availability solution by using database mirroring.
The current application includes programming logic that will retry transactions if a failover occurs.
You need to configure a strategy that will provide the minimum amount of latency for committed transactions.
What should you do?
A.
Pause database mirroring.
B.
Configure manual failover role switching.
C.
Configure forced service role switching.
D.
Configure automatic failover role switching.