WMI Notfication and database mirroring
Posted
by user22215
on Server Fault
See other posts from Server Fault
or by user22215
Published on 2010-02-02T02:14:32Z
Indexed on
2010/04/10
13:23 UTC
Read the original article
Hit count: 220
sql-server-2008
Hi all I'm having a problem configuring a WMI alert that I would like to use with database mirroring. I'm running on Windows 2008 Enterprise X64 with Server 2008 Enterprise X64 also SQL Server has SP1 installed. Basically I click on alert select WMI after that I typed the below SQL statement
SELECT * FROM DATABASE_MIRRORING_STATE_CHANGE WHERE DatabaseName = 'testmove' AND State = 8
I have also made sure the service broker is enabled for the msdb and all mirrored databases however I still can't get this to work basically the alert never fires. I'm testing with just the alert functionality I have not even added in the agent job yet. I tested this by right clicking on my mirrored database and forcing it to fail over. Any help with this problem would be much appreciated
© Server Fault or respective owner