Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Un-clustering a simple 2 node SQL cluster

Created: 18 Jul 2014 • Updated: 19 Aug 2014 | 11 comments
This issue has been solved. See solution.

Can anyone point me in the direction of some good articles or info on removing clustering all together.  Here is our setup, 2 physical nodes, SFHA 5.1 SP2, 2008 enterprise 64bit, SQL 2005.  We just don't need the clustering component anymore and are looking to actually virtualize this workload at some point as well. 

Operating Systems:

Comments 11 CommentsJump to latest comment

Gaurav Sangamnerkar's picture

Hi,

You can find the information in install guide ,refer below

http://static-sort.symanteccloud.com/public/docume...

 

G

PS: If you are happy with the answer provided, please mark the post as solution. You can do so by clicking link "Mark as Solution" below the answer provided.
 

Riaan.Badenhorst's picture
  1. Offline the service group
  2. Delete the service group
  3. Use the configuration wizard to delete the cluster.
  4. Import the diskgroups, mount the volumes, and copy/backup your data databases

Note, virtualization is not going to give you HA. So we assume that you deem these SQL databases are not mission critical and you can tolerate failure. VMware HA is not HA, it just provides failover in case of ESX failures. If you feel that the FULL vcs stack is a bit too much for your environment you might consider ApplicationHA from Symantec (http://www.symantec.com/application-ha) it can monitor and restart the databases so you at least have some level of protection for them.

Regards,

Riaan Badenhorst

You need an OpenVision to see the truth about Backups. Restores are a plus. But that's just Semantics ;)

ITs easy :)

krash's picture

Thanks for the responses.  We plan to continue using one of the cluster nodes and then doing a P2V to convert it to a virtual server.  The customer is not 100% sure what runs everywhere so I'm trying to be as unobtrusive as possible.  Here are my main concerns.

What needs to be done to the SQL server after removing clustering, just renaming the instance?

We would uninstall Symantec storage foundation, enterprise administrator, and Veritas cluster server.  Does anyone see any issues with mounting the SAN disks that were previously managed and signatured by EA? 

 

 

Riaan.Badenhorst's picture

Do you only want to remove it from one of the nodes in the 2 node cluster?

Regards,

Riaan Badenhorst

You need an OpenVision to see the truth about Backups. Restores are a plus. But that's just Semantics ;)

ITs easy :)

krash's picture

We are getting rid of both physical servers so remove or just turn off the second node and format it.  Either way we'd like to convert this to a VM preserving the entire OS/system but just remove the clustering and disk managment software.

 

 

Riaan.Badenhorst's picture

Ok, you can follow this process

  1. Offline the service group
  2. Delete the service group
  3. Use the configuration wizard to remove one node from the cluster.
  4. Then you should use the configuration wizard and reconfigure the cluster to not use LLT. Configure it as a one node. It wont use LLT/GAB and the private heart beat NICs. The reason for this is that if you P2V it, the LLT config that is there now, will get messed up (and you don't need it for a single node).
  5. You dont need to do anything to the SQL installation.

Hope that helps.

 

Alternatively, you can install SF + SQL in the VM (after step 3) and then just create a cluster between the physical and the virtual. But this is more work but safer. I'm not sure what else mght go wrong in a P2V.

Regards,

Riaan Badenhorst

You need an OpenVision to see the truth about Backups. Restores are a plus. But that's just Semantics ;)

ITs easy :)

krash's picture

OK, so we've done a P2V and have a server we can test with.  We would like to keep the server off the network while we remove the cluster software but HAD and VCSComm services won't start so it won't allow me to bring up the cluster monitor to delete the service group.

Any suggestions for deleting a SG from a server that is offline, and/or something that will allow me to uninstall SFHA?

Riaan.Badenhorst's picture

Did you follow the steps i put up?

Regards,

Riaan Badenhorst

You need an OpenVision to see the truth about Backups. Restores are a plus. But that's just Semantics ;)

ITs easy :)

krash's picture

I would but you can't bring up cluster manager to do those steps.  This is production so we are doing the test on a P2V image of the server first. 

I'd like to remove the software completely and was hoping they have a /c (clean) switch during the uninstall, but I'm not finding anything.

 

 

Marianne's picture

We would uninstall Symantec storage foundation,...

Careful! You will not be able to access the data on the SF volumes.

You will need to copy the data off the disks before uninstalling (with SQL shut down) or restore data from backup.

See https://www-secure.symantec.com/connect/forums/migrating-veritas-storage-foundation-volume-windows-disk  

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION
krash's picture

OK thank you for this extremely important fact that I did not realize!  This will put a dent in our plans to remove the cluster/SF/EA software.  It does appear to run OK with the cluster services disabled, although not the optimal solution, but neither is P2V'ing any production server IMHO.