Title: Implementing Log Shipping-Part II-Configuration
Duration: 14:05 min
In this Lesson you will learn how to configure Log Shipping using two different servers instances. It shows step by step the way to do it in an easy way to learn.
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.
At the end of this lesson you will be able to Enable the Primary Database for Log Shipping, Set the backup options, enable secondary servers and set log shipping restore options.
Technologies Used: Sql Server 2005.
Keywords: Sql Server 2005.