Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alert when no witness Expand / Collapse
Author
Message
Posted Wednesday, April 2, 2008 4:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 5, 2009 11:49 AM
Points: 1, Visits: 13
Hi all, I created an alert to send an e-mail where Witness is no present on my Mirroring Configuration, but it is not firing the alert when I disconnect the Witness.

USE [msdb]
GO
/****** Object: Alert [Sin Witness] Script Date: 04/02/2008 15:15:16 ******/
EXEC msdb.dbo.sp_add_alert @name=N'Sin Witness',
@message_id=0,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@category_name=N'[Uncategorized]',
@wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER',
@wmi_query=N'SELECT * FROM DATABASE_MIRRORING_STATE_CHANGE where state=10',
@job_id=N'00000000-0000-0000-0000-000000000000'

Could someone tell me what is wrong?

Thank you
Post #478894
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse