Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

A node was evicted from a windows cluster without first uninstalling the sql first. When the node was put back, an error was produced when we tried to failover. It was reporting a missing dll. Feels like removing the node before uninstalling sql from it has corrupted or deleted part of the build.

Has anyone else encountered this situation? Can this be repaired or is it best to uninstall the sql from the node and start again installing a new sql node.

Thanks!

share|improve this question
    
What is the error message in windows event log / Cluster logs and sql server error logs ? That will help to see exactly what is going wrong. –  Kin Dec 2 '13 at 22:42
    
The error was "the node was added successfully but the sql server resource type could not be installed on it. Unable to find sqsrvres.dll on any of the cluster nodes" - this was the same error for sql server agent –  DBAWaffle Dec 2 '13 at 22:49
    
was the node primary before being evicted? –  swasheck Dec 2 '13 at 23:11
    
This was passive at the time it was evicted –  DBAWaffle Dec 2 '13 at 23:28

1 Answer 1

I would first run a repair installation of your SQL Server installation on the node that was evicted. This should at least get the appropriate binaries installed. Then, run a Discovery Report to validate what is and is not installed. If your SQL node installation is no longer available, the reinstall the node.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.