checking database online or not

• mohan.pariveda

  Ten Centuries

  Points: 1210

  More actions

  July 9, 2009 at 7:11 am

  #208041

  Hi friends,

  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.

  thanks,

  mohan

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  July 9, 2009 at 7:49 am

  #1022370

  Duplicate post, please answer here, http://www.sqlservercentral.com/Forums/Topic750186-146-1.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question