Replication - Publication Failure Alarm
|
|
Note: Connections to SQL Server Replication is available for SQL Server 2005 and later. |
The Replication - Publication Failure alarm alerts you to any publications that have failed.
When the alarm is raised
- Look at the Publications grid on the Publications page of the SQL Server Replication | Activity Drilldown to see which publication failed.
- Look at the history of the agent involved. To do this:
- Go to the Publications grid on the Publications page in the Activity drilldown.
- Select the affected publication.
- Click the Agents tab.
- In the Agent column of the Agents grid, click the link for the affected agent.
- Click the Sessions tab.
- Select the session in the Sessions grid. The informational and error messages logged for that session are shown in the Top 200 Actions grid.
Configuration
- You can configure this alarm to ignore certain values. For more information, see Do not alarm for certain values.
- You can configure different alarm severities for specific publications. For more information, see Configure an alarm.