How I can make all SQL cluster nodes on the same version level
We have SQL 2005 cluster (2 nodes). One of the node on service pack 2 and the other node without service pack. This cluster was configured long time ago by a vendor. I think that the seconed node was added after they have applied sp2 to the first node.
The issue is whenever the failover happened, most of the jobs failed because incompatiltiy. I have tried to apply service pack 2 again it shows errors and rolling back all the actions. I am thinking in 2 action plans:
1- either I go to apply service pack 3 to the cluster
2- remove the node (which without service pack) and re-added again