New SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to Log Shipping in SQL Server 2005

Pt. 1 - An Introduction to Log Shipping in SQL Server 2005 - view details

Log shipping has been around as long as disaster recovery has been a topic. Log shipping (sometimes called setting up a warm standby server) is a simple process that can be written by hand (you 'roll your own') using stored procedures and SQL Server jobs.

This video talks about how log shipping works as well as covering the basic terms and concepts of log shipping.

Highlights from this video:

• How log shipping can be a disaster recovery (DR) technique
• How log shipping is different from (and similar to) Database Mirroring and SQL clustering
  
• Primary servers, Monitor Servers, and Standby Servers
  
• The goals of log shipping
  
• How does log shipping work in SQL Server 2005?
  

and much more

---

• Source: http://www.learnsqlserver2005.com
• Category: Disaster Recovery: Backup, Recovery, Log Shipping, Clustering and Database Mirroring
• Skill Level: 400 (Intermediate - Advanced)
• Length: 9:45 (6.66MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: standby servers, warm standby servers, disaster recovery, clusters, witness