I've set up several maintenance windows for my SQL environment but I'm still getting 1500 emails every weekend most of them from times during the window.
These messages are SQL Server instance unreachable .. this happens due to the snapshot backups of the servers themselves not sql back ups.
Error: 4014, Severity: 20, State: 11.
A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0).
at 1AM when I have a maintenance window set from 00:30 for 45 minutes. The time zone for the servers are the same.
I saw an older post about version 5.0.7 where they said the maintenance window only suppresses messages in regards to performance but still shows unreachable messages?
Is this still true? Is there any way to stop all messages during these windows?
I would also like to know if there is a way to tell it to ignore a specific alert from a specific source IP address..
we have another program that scans the network and it send about 40 error messages every time it scans and this scan happens outside the normal maintenance window