SQL Server Performance

Alerting on Database Mirroring Events

Discussion in 'SQL Server 2005 Database Mirroring' started by contactjimmyus, Sep 11, 2008.

  1. I wish to monitor and log the db monitoring state event .I tried with the link
    http://www.microsoft.com/technet/prodtechnol/sql/2005/mirroringevents.mspx Script Sample - Record Database Mirroring State Changes
    It is raising the alerts but it is not saving into a table I have checked token replacement in sql agent properties alerts link.
    Let me know any script that i can use to log the mirroring state changes to a table
    Thanks
  2. satya Moderator

    Do you see any alerts or warning during this time>
  3. I have tested the alerts and it is working fine. I have replaced the job with script with a simple insert statement to statechanges table and it is working fine I have change the script as below and it is failing to insert into the table .Please share how to use escape _none feature or how to log the info in to tables
    INSERT INTO dbo.StateChanges
    (EventTime),(EventDescription)

    VALUES (
    getdate(),$(ESCAPE_NONE(WMI(TextData))

Share This Page