Log shipping is a disaster recovery technology, as there is no automatic failover available with this solution. With database configured for log shipping, there are several automated jobs that periodically back up the transaction log and restore the log to a different server. This server can be used for many scenarios like:
- Disaster recovery
- Reporting offload
Disaster recovery configuration is mainly used for a warm standby server, which has data nearly synchronized with the master server and can be brought up quite quickly providing we have all the backups available up to the point of the disaster. Log shipping has quite a simple architecture, where you have only two main server roles--primary and secondary. With log shipping, ...