Title: Implementing Log Shipping-Part III-Log shipping modes
Duration: 12:00 min
Summary:Log shipping is the automated process of backing up, copying, and restoring the transaction log from one database on a primary server to one or more secondary databases on another server. Using log shipping, you can frequently synchronize the copy of the database with the original, so you can use the copy to distribute query processing for improved performance or as a warm standby database for high availability.
In this Lesson you will learn how set log shipping modes, this impact the way you want it works, emphasizing availability or load balance.
At the end of this lesson you will be able to explain the differences between no recovery and standby mode and know how to configure it.
Technologies Used: Sql Server 2005.
Keywords: Sql Server 2005.