Log shipping is used to establish one or more secondary databases that can be brought online manually if a primary database fails. Following is an overview of log shipping and then a discussion of how it is implemented.
Log shipping requires at least two separate SQL Server instances:
A primary server instance on which you have configured a database to act as the primary for log shipping
A secondary server instance on which you have configured a database to act as the secondary for log shipping
All administration of the log shipping configuration is performed on the primary server. You can extend log shipping in several ways:
By configuring multiple secondary databases, you can establish multiple standbys ...