Failing Over and How Failover Works in a Clustered Environment - Video Series Video Category: Disaster Recovery: Backup, Recovery, Log Shipping, Clustering and Database Mirroring Skill Level: 500 (Advanced) Versions/Editions Covered: SQL Server 2005 Arrrggghhhh! Disaster! RED ALERT! RED ALERT! Do we have your attention yet? Good - you'll need it because the disaster is here: your active node is down. What do you do? Do you have to do anything or will the cluster do it automatically? (If you're asking yourself, 'Why even have a cluster if it won't do it automatically?', then that's just great)

Videos in this Series:

Title Skill Length Download Pt. 1 - Transactions and Failover   500 19 mins. Download Pt. 2 - Transactions and Failover   500 10 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Book You Should Probably Own: Kalen Delaney's "Inside SQL Server 2005" Performance Tip: "WHERE LastName LIKE 'Sm%'" is a fast query but "WHERE column LIKE '%Sm%' is a performance killer. Imagine searching in a phone book for anyone whose last name starts with 'Sm' - easy right? Now try to find anyone whose last name contains the two letters 'sm'. There's a huge difference in the number of pages required to satisfy the two queries Helpful Keyboard Shortcuts: "CTRL" + "Page Up" navigates forward between panes/worksheets/tabs in an application (use "Page Down" to navigate backwards)