February 1, 2010 at 7:11 pm
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
February 2, 2010 at 7:20 pm
I was able to fix the problem I found a blog that explained all of the mirroring states
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply