Hi all. I have my application which will run in clustered environment. But in case of failover i am seeing some weird behaviour. The problem is stated as follows: I have two nodes(machines) clustered using MSCS cluster service. I have installed my application on both nodes. Now i cluster my application using cluster api's creating my own group,my own list of resources for that group and add sql db service in that list of resource of my group. During clustering my application i place sql files(mdf and ldf files) at a centralised place and attach to those DB files at the end of the clustering my application. Now after clustering is successful when i launch my application its running fine on active node(first machine). But when i fail over the first machine (that means shutdown) then the MSCS cluster service detects fail condition and accordingly which is passive node will hand over the control to that machine. During this process all services in resource group gets restarted in passive node. In this process the sql service is not able to attach my Db files. It is giving sql error "824 severity 24 state 2" in sql error logs. But if see in cluster administrator i see sql service has started successfully. But seeing in sql logs i feel the sql was not able to recover my application DB.
Sorry for the long story. Can anyone help me to understand what exactly is causing the issue??