Event Forwarding
Similar to multiserver job management, SQL Server can also be configured to forward error messages. All or any unhandled event messages that meet or exceed a specified severity level can be sent to another server for processing. For example, you can configure all your servers to forward level 17 or greater messages to an underutilized departmental server. The advantage here is that the alerts, jobs, and operators that respond to the error need to only be configured on the one server. The disadvantages are increased network traffic, and, perhaps most importantly, a single point of failure has been introduced. If the server that is handling the events or its network segment is down, then you are in peril of missing events from ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
