---
title: "What is log shipping in sql server?"  
description: "What is log shipping in sql server?"  
author: "Sumit Kesarwani"  
published: 2013-12-22  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/1849/what-is-log-shipping-in-sql-server  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# What is log shipping in sql server?

Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. Enterprise Editions only supports log shipping. In log shipping the transnational log file from one server is automatically updated into the backup database on the other server.

## Answers

### Answer by Sumit Kesarwani

Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. Enterprise Editions only supports log shipping. In log shipping the transnational log file from one server is automatically updated into the backup database on the other server.


---

Original Source: https://www.mindstick.com/interview/1849/what-is-log-shipping-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.