Custom Alert for SQL Instance failover

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

I suppose the notification doesn't fire because the instance is not running during the failover.

-- Gianluca Sartori

t_ciossu SSC Enthusiast Points: 196 More actions · Answer 2

Yea, maybe you're right, the instance is in a start-up mode, but that text is in the actual sql log.

Anyway, I managed to find a way around that using the following command:

xp_ReadErrorLog 0,1,'NETBIOS'

that's gonna search the current sql log for NETBIOS entry and return, if exists, details about it.