From the course: Database Foundations: Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Synchronize servers with log shipping
From the course: Database Foundations: Administration
Synchronize servers with log shipping
- [Instructor] When you have a warm standby server, the most common method of keeping it in sync with your primary server is called log shipping. Log shipping takes advantage of the transaction logs that your database server is already using. These are the same logs that we discussed way back in chapter one in the movie on point-in-time restores. The database's transaction logs are the moment-by-moment records of every change that's made to the database. By sending those transaction logs from the primary server to the warm standby server, the database on the standby server can step through and apply the exact same changes in the same sequence. There's three steps to the process here. First, the primary database makes a differential backup of the transaction log. Remember that a differential backup only contains the changes that have occurred since the last backup was made, so this step can be done relatively quickly. Next,…
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.