SQL Server Fails to Start When Moved to Different Node

5130 pts.
Tags:
Failover Clustering
SQL Server
SQL Server 2008
SQL Server 2008 R2
SQL Server clustering
Windows Server 2008 R2
Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the sql server service, sql server and agent startup without problems. Also, I can offline the server on node 2, move it to node 1, and try and start it but it fails unless I delete the errorlog first. I checked startup parameters and servers are identical. I also have a second instance on the same cluster and it moves back and forth between nodes without incident.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Please provide us the cluster logs to investigate.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Genderhayes
    Only  one mode can control a disk at one time
    7,565 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following