SQL Server Offline Event

31 Aug 2006 5:39 PM

John Wright

Is there an event I can watch that SQL Server Fires when it goes off line?
I need to watch for an event to monitor SQL Server status, and when it is
not online, switch to a backup server. I am using .NET (C# or VB) to do
this. Can this be done?

John Wright

31 Aug 2006 5:58 PM

Arnie Rowland

You could verify that the server is on 'online' by running a small, low
impact query every 30 seconds (frequency as needed.)

For example,

SELECT @@VERSION

Set a short, but reasonable, timeout, and if the response is not received in
that time, query again (or not), and take appropriate action.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"John Wright" <riley_wri***@notmail.com> wrote in message
news:eLadnRSzGHA.2208@TK2MSFTNGP03.phx.gbl...
> Is there an event I can watch that SQL Server Fires when it goes off line?
> I need to watch for an event to monitor SQL Server status, and when it is
> not online, switch to a backup server. I am using .NET (C# or VB) to do
> this. Can this be done?
>
> John Wright
>