Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
 Posted - 2008-03-24 : 08:55:21
|
| Hi folks,I am operating two machines in a clustered environment on a Win 2003 platform SP1. Further SQL 2000 is running on the primary node and the failover services on the secondary node. Up until now everything was fine wherein the secondary node took control of all the resources and SQL services failoed over when the primary was shutdown or when the cluster group was moved manually through the windows cluster administrator. However, now the behaviour has changed in which the resources are transferred but the the SQL Server cluster resource goes to a "failed" state and does not come online. What could be the reason? Could someone help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-24 : 16:51:03
|
| Check Application Log and Cluster log for the reason.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQL Failover services not taking over