What Is Sql Log Shipping?

Marcus Vance
Marcus Vance
• • 7 min read

Sql Server Log Shipping Allows You to Automatically Send Transaction Log Transaction Log in the Field of Databases in Computer Science, a Transaction Log (Also...

What Is Sql Log Shipping?

SQL Server Log shipping allows you to automatically send transaction log

transaction log
In the field of databases in computer science, a transaction log (also transaction journal, database log, binary log or audit trail) is a history of actions executed by a database management system used to guarantee ACID properties over crashes or hardware failures.
› wiki › Transaction_log
backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually.

How does log shipping work?

Log shipping involves copying a database backup and subsequent transaction log backups from the primary (source) server and restoring the database and transaction log backups on one or more secondary (Stand By / Destination) servers.

Must Read

What is the difference between log shipping and replication?

Log shipping involves two copies of a single database that typically reside on different computers. ... Replication does not continue after a log shipping failover. If a failover occurs, replication agents do not connect to the secondary, so transactions are not replicated to Subscribers.

Marcus Vance

Marcus Vance

Cybersecurity & Digital Privacy Researcher
Twitter Github Linkedin

Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.