checking database online or not

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » checking database online or not

checking database online or not

Rate Topic

Display Mode

Topic Options

Author

Message

mohan.pariveda

Posted Thursday, July 09, 2009 7:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, December 02, 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 #750186

Jack Corbett

Posted Thursday, July 09, 2009 7:48 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

You can query sys.databases to see if a database in online or not and then use sp_senddbmail to sendo ut a message or you can write an error out and create an alert based on that error.

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 #750232

« Prev Topic | Next Topic »

Permissions