Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

checking database online or not Expand / Collapse
Author
Message
Posted Thursday, July 9, 2009 7:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 2, 2010 9:07 AM
Points: 34, Visits: 128
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
Post #750183
Posted Thursday, July 9, 2009 7:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
Duplicate post, please answer here, http://www.sqlservercentral.com/Forums/Topic750186-146-1.aspx



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #750236
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse