New SQL Server 2005 Video Tutorial: Pt. 7 - How to Failover Your Log Shipped Database to the Standby Server

Pt. 7 - How to Failover Your Log Shipped Database to the Standby Server - view details

Something bad - really bad - has happened and it's now time to fail over to the standby server. How do you do it? What's the process?

Highlights from this video:

• How to manually failover
  
• How to fail back
  
• Concepts of failover
  
• How to achieve point in time recovery
• Best practices for Log shipping
  

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: 11:45 (11.2MB)
• 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