What is log shipping?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is log shipping?
Rating:
Log shipping sends transaction log backups from a primary server to one or more secondary servers. An optional third server, known as the monitor server, logs the history and status of backup and restore operations and raises alerts if these operations fail to occur as scheduled. Log shipping backs up the transaction log at the primary server, copies the transaction log file to the secondary server, and restores transaction log backups on the secondary servers. Log shipping involves four jobs that SQL Server Agent jobs handle. These jobs include the backup job, copy job, restore job, and alert job.
Rating:
Was this information helpful?
Other articles
- What is the xml data type?
- What is the dtutil utility?
- What is the dtexec utility?
- What is the model database?
- What is the processadmin fixed server role?