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)
 Microsoft Clustered server running SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-11-19 : 08:32:34
Brent writes "For fail over testing, I moved the cluster from one node to the other node, it successfully moved including the SQL cluster. I moved it back to the original node and it moved sucessfully. I did this again and now SQL will not load. I am getting an event id 17055, category(2) Description 18052:
Error: 9004. severity 23, State:1 . Any ideas on what may have happened?

Brent"

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2002-11-19 : 08:41:19
When you say SQL will not load, do you mean the services will not come up, or your database will not come up? The only thing I could find on the error was possibly something to do with the transaction log being either full or transaction log backups not having any transactions due to truncation of the log. Do you get any actual error message?

***************************************
Death must absolutely come to enemies of the code!
Go to Top of Page
   

- Advertisement -