Title: Implementing Log Shipping-Part I-Introduction
Duration: 10:18 min
Technologies Used: Sql Server 2005.
Summary: In this Lesson I will give an overview and introduction to the Disaster Recovery and High Availability solution called log shipping which can be implemented using sql server since the seventh version, but we are going to focus on the Sql Server 2005 version. 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.Covers How it is used and implemented, the Components involved, the processes that are used in the solution and the requirements to implement it.
Keywords: Sql Server 2005.