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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Both servers stopped

Author  Topic 

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2006-11-05 : 12:50:30
We have SQL 1 and SQL2 both clustered
Over weekend neither could be reached in SQL EM or Ping them...

The network guys rebooted both SQL Servers twice then they finally started working.

Where do i start looking why would both go down...would this be the cluster failed?

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-11-05 : 15:00:48
I would start by looking at:
The system, application, and security event logs on all servers in the cluster.
The SQL Server logs.

Ask questions to find out if there were:
Any problems with power.
Any problems with network equipment.
Any other equipment that had similar problems.





CODO ERGO SUM
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-11-06 : 04:40:56
reservation for shared disk ownership? Restart one after the other, not simultaneous...just trying out if my esp still works

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -