I have a SQL Server Policy that forces databases (with exceptions) to be in Full Recovery. Issue is that facet doesn't allow for "on change:prevent" so i have it on a schedule. Is there a way to get an email anytime the policy fails?
Tell me more
×
Server Fault is a question and answer site for
professional system and network administrators. It's 100% free, no registration required.
|
|
|
You likely considered setting an alert based upon the message number associated with the failure and let this generate the email (via dbmail). |
|||
|
