Post reply

SQL server alerts when database stops

  • March 21, 2006 at 3:05 pm

    #152845

    HI. I would like to set an alert or send some kind of message to our operators in the computer room when the sql server shuts down unexpectedly. can someone tell me how i would go about doing this?

    Also, since the operators do not have enterprise manager installed on their pc's, how could they go about restarting sql server?

     

    Thank you,

    Juanita

     

  • March 21, 2006 at 3:26 pm

    #627987

    hopefully someone else will chip in on how to alert the operators;

    all services on a server can be started and stopped with the NET START /NET STOP command:

    Command promptStart an instance of SQL Server or the SQL Server Agent service from a command prompt by typing:

    net start mssqlserver or sqlservr, or net start SQLServerAgent or by running SQLSERVR.EXE. If you are referring to a named instance of SQL Server, you must specify mssql$instancename or SQLAgent$instancename.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 21, 2006 at 3:31 pm

    #627988

    Thank you so much. This is a start for me.

    JUanita

     

  • March 22, 2006 at 6:53 am

    #628073

    i learned a bit more myself; if you go to a command prompt and type net start the list of all services will be displayed;

    pretty much every service listed will respond to the net start,net stop,net pause,net continue commands.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 22, 2006 at 7:17 am

    #628084

    THANKS !!!

    Juanita

  • March 23, 2006 at 12:53 pm

    #628449

    Depending on your environment, a great tool I've found to do this is called Servers Alive.  http://www.woodstone.nu/salive/  You can do everything from a simple ping to checking the statuses of certain services etc.  It's very inexpensive $139 for 1000 checks, or do 10 checks for free.  I had it set to check individual SQL instances,  when ever one was stopped, etc it would email me.  It can also be used to capture network traps etc. 

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply