Is there anyway to have multiple maintenance modes for a single sql server.
I have three minor outages a month: Monthly patching, snapshot reboot and a data refresh.
As far as I can tell, the SQL Diagnostic Manager tool can only have one maintenance mode.
Anyone have a way around this issue?