Is there a way to get notified when SQL server goes down or offline? I have a SQL server instance that runs on a remote server in south Dakota. Just a couple of days ago, the server went offline or went down, for lack of better word, after business hours and I didn't find out until the next business day. I asked the company who manages the server why the server went down but they could not tell me why. Does anyone know how to investigate what caused SQL server to go offline and how to get notified when SQL SERVER goes down?
It's hard for a server to notify you when it's down. What you need is to have a server that monitors if other servers are up and functioning. This server is the one that would notify you if any of the other servers go down. This should be implemented on more than one server,so that you have at least one server monitoring the monitoring server too.