·
Database Mirroring benefits
o Instantaneous synchronization
of changes
o Automated failover (in High
Availability Mode)
o Fast failover. (if no
transactions are queued)
·
Database Mirroring limitations
o Synchronous mirroring is
intolerant to latency and bandwidth constraints
·
Log Shipping benefits
o Delay of restore job can
protect from database corruption
o Perhaps more tolerant to
latency than sychronous mirroring
o Doesn't affect performance of
primary server
·
Log Shipping limitations
o No automated failover
