I have to check my Sql Server databases are online or not as part of my daily Server monitoring.
I am checking this by logging into each and every server.
but our requirement is we need get alert when the database is offline/down.
that means a script which will ping/ check the state of the database on repititive intervals.
Can anyone please help me for this script.