From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Log shipping

Log shipping - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Log shipping

“

- [Instructor] In the chapter on creating backups of the database, we looked at the concept of backing up just the transaction log, so that it could be essentially replayed on a previously taken full back up, in order to bring it up to date. This concept can be applied automatically and continuously to create a high availability solution called log shipping. With log shipping, a primary production database sends transaction log backups to one or more secondary databases, on a secondary instance of sequel server. These secondary databases are duplicate copies of the primary database and continually restore the transaction log backups to their own copy, in order to keep it in sync with the primary database. Because the secondary database is on physically separate hardware, should the primary fail for any reason, the fully backed up copy of the system is immediately available and network traffic can simply be rerouted to the secondary server, without any users knowing that a fault has…

Contents