Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Jordon Pilling,
Ever come across a 64bit SQL Server with more cores than you can shake a stick at, with a but load of Mirrored databases with no mirroring alerts what so ever?
This script has 6 main parts:
This script will create alerts for each mirrored database, the alerts created will cover:
To use the script, simply paste it into a new query window on your principle, do a find replace on "XXXXX@YYYY.COM" and replace with your DBA address, then execute. Repeat on the Mirror.
This is version 8 of the script, based on feedback in the discussion thead.
How get Alerts when Database Mirroring Fails
T-SQL Script to create a SQL Mirroring:-
The first thing you need to do when setting up Database ...
When creating an alert