bsarahim
asked on
SQL server repair option on Node1 Cluster
what are the cautions we need take in SQL Server 2012 std( windows cluster 2012) and Node1, Node2 are in cluster
as sql server 2012 sp4 patch upgrade we unable to install because of some installer files are missing, we tired to fix, but it is not working and we are decided to go for SQL server Repair option on Node1
Pls let me know, what steps do i need to do..with a caution..on Node1
Pls note, once if it successful patched on sp4 on node2, after repair, then we will plan on node2.
Pls suggest. Thanks
as sql server 2012 sp4 patch upgrade we unable to install because of some installer files are missing, we tired to fix, but it is not working and we are decided to go for SQL server Repair option on Node1
Pls let me know, what steps do i need to do..with a caution..on Node1
Pls note, once if it successful patched on sp4 on node2, after repair, then we will plan on node2.
Pls suggest. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i've had this before when a drive letter has been changed that was used during install. i managed to find the path in registry and added a drive with that letter. updates then worked. But as above, best thing with clusters get everything working on node 2 and add another node or fix node 1.
if it helps justify, remember with vm, you're not using any cpu's or ram performance to begin with so should be possible unless other restriction. once you remove node1 and failover to new node 3, that's the only time new vm will be using host performance.
ASKER
Pls dont propose me any other VM/Cloning,snapshot etc (anyways i will take this as a backup)
what are the technical issues will come during sql repair or reinstall on sql server 2012 on Node1, your experiences matters. Pls share thanks
what are the technical issues will come during sql repair or reinstall on sql server 2012 on Node1, your experiences matters. Pls share thanks
Technical issues will be that there is no failover during repair/fix of node 1. Adding a 3rd node keeps redundancy. Otherwise remove node 1 and repair/ reinstall.
ASKER