Sir, I have a small issue with this actually. when I look at job history it shows me a stopped in red marks and it doesn't look good if someone...

Hi Perry,

Your advise is working like a charm. Thank you Sir 🙂

Thanks for the quick reply Sir. Thing is that I would like to implement such a logic, which doesn't even let the job to start if it is not primary......

sp_Find ':\logs'

In other words I want to list out all jobs steps which has @output_file_name.

Thank you for the help. However, I am looking for anything which works on sql 2008 and above versions.

Yes Sir. Its the same database name.

Thank you. Will do that. We are seeing this very often.

Thank you for the suggestion Eiriksson. I will check online as suggested.

Thank you.

Thank you Anthony.

Thank you for valuable inputs.

Thank you Sir.

Thanks a lot Perry. so kind of you. I am not a expert on cluster. Just want to clear some concepts and definitely I will try building VMs and try...

Thanks Perry. Again, what is split brain? I have read that whenever private/heartbeat network fails, split brain occurs?

Consider I have a 3 node cluster (N1,N2,N3) and private network completely...

When the private network goes down cluster communications will carry on through the public network. Loss of a private network does not initiate a failover. The loss of the public...