Re-installation required of OS on one node in two nodes SQL Cluster
OS = Windows2008R2
SQL Server = 2008
One of our client have Two Nodes Cluster for SQL Server. Passive Node OS is miss behaving while rebooting and seems not able to getting fixed by client. Client is willing to re-install the OS of Passive Node. Below are the steps which seems below to do this activity.
1.) Run the Cluster Configuration Wizard.
2.) Delete the Passive Node.
3.) Install OS, sfha (same patch level as Active Node).
4.) Install SQL Server (same patch level as Active Node). # at this step we further do the below My Idea steps
5.) Run the Cluster Configuration Wizard on Active Node.
6.) Add the Passive Node.
When we do step # 4. in an environment which is a brand new fresh, while SQL installation we give the Central Storage/SAN for the data files(.mdf and .ldf) and then click on NEXT to continue the SQL Server installation. In my this situation we have already data files created on SAN drive and these drives are mounted on Active Node. How can we locate .mdf and .ldf file while SQL installation step when we need to define data files. Recommandation required please.
Define the data files (.mdf and .ldf) to any where else. when SQL installation complete. Below are the steps seems to be taken.
Offline Service Group on Active Node.
Import the DiskGroup on Passive Node from VEA (Veritas Enterprise Administrator).
Call SQL Server DBA to define the path setting under SQL Server which locate SQL Server to see data files under DiskGroup Volumes.
Deport the DiskGroup.
Online Service Group on Active Node again.
Run step # 5 and # 6.