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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-11-30 : 01:45:27
|
| SQL services are not running on 2 node clustersWhen i checked in eventlogs i found error that 'the node lost communication with cluster node 'passive node'on network 'backup_0c1' 'Is it a cluster failover? or do i need to start sql services manually on active node?please adviceladdu |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-30 : 01:57:52
|
| Check it in cluster admin, start sql there if needed. Seems there was network issue on the cluster. |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-11-30 : 02:19:23
|
| server was rebooted 2 days ago, and sql services are in manual state...do i need to start services manually? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-30 : 03:59:44
|
| yes you do. They should be set to automatic. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 00:24:36
|
| No, can't set to automatic on cluster. Should check sql server log, windows event logs and cluster log to find out why sql service stopped. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-02 : 01:24:39
|
| As per investigation I found that Server was rebooted..and i started sql services manually. Please tell me if anything is to do from myside |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 01:27:16
|
| Cluster service should bring sql up if set cluster properly, work with your windows admin to find out why didn't work that way. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-02 : 01:38:50
|
| Yep..I will do Thanks alot |
|
|
|
|
|
|
sql services are not running