Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
   
SQL Server Training Videos
SQL Server DBA Videos in Series Home  Subscriber Videos  

Failing Over and How Failover Works in a Clustered Environment (Video Series)

Video Image Video Category: Disaster Recovery: Backup, Recovery, Clustering, Mirroring, Log Shipping

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:


Miscellaneous Bits & Pieces:
The scripts to rebuild the Northwind and Pubs database are included in the MSSQL\Install folder
Performance Tip: Know your hot set. The "hot set" is the amount of data that your users are currently working with in the database. You want to ensure that you have enough memory in the system to cover (a) the OS requirements, (b) the SQL Server process requirements, (c) the hot set, and (d) a little extra in the event that you need it.
SQL Server 2000 Resource Kit - More Helpful Tools: SQL DMO has many nice examples of using DMO to script your SQL Server administration

Other Websites We Offer
LearnCSharp.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
9/7/2008 9:17:31 PM