From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Log shipping

Log shipping - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Log shipping

“

- [Instructor] The transaction log in a SQL installation is an important file. Recall your transactions in the database, such as updates, inserts, and deletes are written to the transaction log first, and then to your tables when the database engine determines it is a good time to do so. Log shipping offers the following advantages. It provides a disaster recovery solution, and it supports limited read-only access to secondary databases, during the interval between restore jobs. It also provides for setting a delay between when the primary server log backup and secondary servers restore. Why would we use log shipping? Well, we can automatically send log backups to a secondary server, if that's what we decide to do. It preserves those transaction logs for the recovery later on. We can also set up a monitoring server, and this is a third server instance that acts as a monitor server, and can actually record the history and status of the backups and the restores as they take place. The…

Contents