Log Shipping in SQL Server has been around for a while and still provides an easy method for redundancy and load balancing. It uses standard backup and restore technology to ship backups to a standby ...
As I understand it if you are using mirroring on SQL server and have failover setup you can adjust the connection strings of your applications that use it so they know the name of the other server to ...