New answers tagged mirroring
2
Read Step by Step Guide to Setup a Dedicated SQL Database Mirroring(DBM on dedicated Nic card)
It shows you how to configure Mirroring on Dedicated NIC card. Network configuration plays an important role in the performance and safety provided by database mirroring.
Also, worth reading Database Mirroring Best Practices and Performance Considerations ...
2
For a weak network I wouldn't personally use Mirroring. But if you really want mirroring for the specific case when there might be a slow connection an option would be to use the Asynchronous mode (or High Performance mode). This would imply some data loss would be possible, but you will be able to finish transactions faster.
Details on MSDN: Async ...
2
You should be able to bind mirroring to a specific IP address (that of your crossover cable) by using the LISTENER_IP option of CREATE ENDPOINT / ALTER ENDPOINT.
Presumably this will involve reconfiguring your mirrored databases by using ALTER DATABASE SET PARTNER... to point to your other endpoint via IP instead of hostname.
I'm not sure if this can be ...
Top 50 recent answers are included
