What is Log Shipping?

Log shipping is a process of copying transaction log files from a primary database server to one or more secondary server locations. It's a disaster recovery and high availability solution. The secondary server can be used as a warm standby, allowing for quick failover in case of primary server failure. It can also be used for reporting to offload read-only queries from the primary server. The process typically involves backing up the transaction log on the primary server, copying the log backup to the secondary server, and then restoring the log backup on the secondary server. This process is often automated.