Sidd's SQL Solution

Ok now this is same soup with different recipe and ingredients, which here means same type of trouble which we discussed in our last post but a very different approach for resolution as the problem is new. Just like last one, nobody wants to be in this situation but unlike the previous situation which we discussed, this one is more severe as it can occur any fine day causing things to go hay wire with people panicking and chasing what has happened. Why their application has suddenly not able to reach to database or why SQL Server is not working. Scenario Now, let me quickly explain the situation here first. This is the situation I recently faced where in one of my projects people start getting “ timeout ” or “ Cannot connect to <Instance> ” error. I quickly reached to the server and found that instance was not up. As it was a clustered server I checked the cluster logs and found that instance failed over before crashing (usual behavior). I tried again to bring the s