Forwarding Events

You can forward all Microsoft® SQL Server™ event messages that meet or exceed a specific error severity level to one server running SQL Server. The forwarding server is a dedicated server that can also be a master server (MSX). You can use event-forwarding to enable centralized alert management for a group of servers. In this way, you can reduce the workload on heavily used servers. A SQL Server version 6.x server should not be configured to forward its events to a SQL Server 7.0 server. This configuration is not supported.

In a multiserver environment, it is recommended that you designate the master server as the alerts management server.

Advantages

Advantages of setting up an alerts management server include:

Disadvantages

Disadvantages of setting up an alerts management server include:

Guidelines

When configuring event forwarding, follow these guidelines:


Note If a locally defined alert is disabled and an event occurs that would have caused the alert to fire, the event is forwarded to the alerts-forwarding server (if it satisfies the alert forwarding condition). This allows local overrides (alerts defined locally that are also defined at the alerts forwarding server) to be turned off and on as needed by the user at the local site. You can also request that events always be forwarded, even if they are handled by local alerts.


To designate an events forwarding server

    

To define the response to an alert

         

See Also

sysmessages

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.