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 |
|
Shastryv
Posting Yak Master
145 Posts |
 Posted - 2003-06-10 : 16:16:02
|
| We are testing SQL Cluster on Data Center with service pack1. We manually Failover the Cluster IP address and it did moved to the other node, as it supposed to be. Now we moved the SQL Group, the Physical disk did came online but SQL Server, Agent, SQL IP Address, SQL Network name shows “Online Pending”. Any idea? Thanks |
|
|
Shastryv
Posting Yak Master
145 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-10 : 16:33:28
|
| It probably is trying to come up and that's why it's in online pending state. It's probably failing back and forth between the clusters. This actually happened to us yesterday. I didn't pay much attention to it because this instance of SQL Server was not in production so I ignored it for awhile. After about an hour it was still in online pending state and I could see it trying to come up on one cluster then fail, then try on the other, then fail, etc... Anyway, I resolved the problem by looking at the Event Log. The Event log mentioned that the Data Center/Clustering account was missing in SQL Server (we had someone delete some stuff from this instance without our knowledge and also they didn't know what they were doing), so I just added the account, then the cluster came online. Long story short, check the Event Log. It will show what is going on.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-10 : 16:40:45
|
quote:
We are testing SQL Cluster on Data Center with service pack1.
Why only service pack 1? SP1 has lots of vulnerabilities. You should install sp2 along with the security patches or install sp3a.Tara |
|
|
|
Shastryv
Posting Yak Master
145 Posts |
Posted - 2003-06-10 : 18:18:59
|
| Thanks for the help tara. I just re-started the Cluster service and it seems every thing is back. Yes there are lots of known Bugs in SP1, I agree with you. We are testing the Failover cluster, so we just installed SP1. |
|
|
|
|
|
|
|
|
Clustering Question