July 25, 2014 at 5:05 am
Hi all
We've got a mirrored database on one of our servers and there's a mirrored database monitoring job set up.
As far as I can see, all it does it write data to a table.
Now, I've got a couple of questions:-
Can I set this job up to email if the originating mirror goes down? If so, has anyone got any pointers? The job runs every minute but I don't want to get bombarded with emails if it does (every 15 minutes will be plenty).
I can see the table in the MSDB database, but I'm not sure what the "Status" field is for. Anyone got any useful links as I'm obviously not searching the correct terms on Google?
I know the originating mirror went down yesterday (it was rebooted), but I can't see any evidence of that for the correct time-frame?
Anyone any pointers on reading the dbm_monitor_data table please?
July 25, 2014 at 10:28 am
Hi Richard,
You can set up a WMI alert in SQL Agent to notify you when mirroring state changes, see the Database Mirroring State Change Events section here:
http://technet.microsoft.com/en-us/library/cc966392.aspx
There's also a script for a table & job that'll record state change history.
I've used these before, very useful. I do recommend limiting the alert to only certain state changes though.
Cheers
Gaz
July 28, 2014 at 1:51 am
Thanks Gazareth, I'll have a look now I'm back at work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy