Hi all experts,
I pretty new in SQL database along with WinServ clustering, so please mind my knowledge level in the overall process.
Base on the screenshot above, we have currently a single cluster created base in which that is controlling DB1 and DB2. Primarily DB1 would be our Active node whereas DB2 would be our Passive, both have it's own designated Public and Private IP. After a
small issue previously in which our cluster service failed, it seems that the failover has taken place in which at the moment is running on DB2, which bears the question now is would it be possible to have DB1 being the Active node without downtime? and what
is the process flow to change reactivate it back?
- Win2k3 Ent Application Server
- Win2k3 Ent DB1&2
- IBM DS5020 SAN Storage
On the disk management on each DB servers, we are not able to see the LUNs in DB1 (shown as Unreadable) whereas on DB2 it is shown as normal, in which we would assume that this is normal since DB2 is the active node.
Thanks for reading & most of my search base on this question ended up in this forum, which I would assume that this is the correct place to ask.
View Complete Post