From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Log shipping overview - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Log shipping overview
- [Instructor] In the chapter on developing a backup strategy, we looked at the concept of backing up just the transaction log, so that it could be essentially replayed on a previously taken full backup, in order to bring you up to date or provide a point-in-time restore. 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 a transaction log backup to one or more secondary databases on secondary instances of SQL 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, a fully backed up copy of the system is immediately available and network traffic can simply be rerouted to the secondary server without end users ever…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.