Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
   
SQL Server 2005 Database Administration Training Videos
SQL Server 2005 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, 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:


Miscellaneous Bits & Pieces:
Security Tip: Run the Microsoft Baseline Security Analyzer (MBSA) on your SQL Server to ensure that you are well protected
Management Tip: Automation is your friend. Make good use of SQL Server jobs and alerts to build a proactive solution. Configure alerts for common scenarios such as backup failures, log filling up, deadlocks and more. Have these alerts fire off jobs that protect and react to the situation. For example, configure an alert that fires off a log backup job if the log of database "MyDb" gets 90% full
Security Tip: The "sa" account is probably best left unused in most organizations. Instead of using the "sa" account assign your Windows login to the "sysadmin" server role and use Windows Authentication to connect.

Other Websites We Offer
LearnTransactSQL.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!
 
1/6/2009 3:54:50 AM