Post reply

Creating an alert for error 15327 ''database offline'' (SQL Server 2000)

  • August 13, 2006 at 7:39 pm

    #113851

    I want to receive an alert/ notification when any SQL Server 2000 database goes offline.

    I have tried setting up an alert for error 15327, but it doesn't activate when I take a database offline.

  • August 13, 2006 at 11:07 pm

    #654737

    When you first set up the alert in SQL Server you should also receive a message telling you that 'error 15327 will not invoke alert <alert object name> by default since this error is not logged by default...'

    You can easily check this in the SQL Server Log when you bring the database offline - nothing is logged. However, when you bring the database online again, there is a record in the log file!

    The SQL Server Agent service will periodically scan the event log to determine if the event matches the enabled alert. Since there is no logging, the alert is not fired.

  • August 13, 2006 at 11:38 pm

    #654739

    I did try the following to make SQL Server log the event:

      EXEC sp_altermessage 15327, 'WITH_LOG', 'true'

    Despite the command, SQL is still not logging the event.

    My basic requirement is that I be automatically notified my email when a database goes offline.

    Any suggestions on how to achieve this would be much appreciated.

Viewing 3 posts - 1 through 2 (of 2 total)

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