Log shipping

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, ...

Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.