Maintenance plans - Back Up Task appear to be ignoring the ignore offline database checkbox resulting in 18456 events.
SQL Server 2016, SP1-CU3 - Back Up Task maintenance plans appear to be ignoring the
checkbox to "Ignore databases where the state is not online." Instead we are seeing a
rather annoying number of 18456 events in the event and SQL Server Log.
Mind you I have not caught SSIS red-handed in a trace as the source of our login-failures
but it is fairly obvious as the agent's domain account is the one recorded as failed to
login at the same time we are performing maintenance plan backups.
Upvotes: 1<=-=Nov 28 2017 8:19AM=-=>
Update, did some review and confirmed SQL 2016 SP1 CU5 Maintenance plans
are ignorant of the “IgnoreDatabasesInNotOnlineState” setting. As per
https://msdn.microsoft.com/en-us/library/gg617041(v=sql.105).aspx when set to
“True”, offline databases should be ignored. Unfortunately ignorance of this
setting produces a significant number of 18456 events which makes monitoring
for actual attach vector more difficult.
Is this solved ? And in which cu is this fixed ?
Seeing the same problem with a client's SQL server 2016 SP1-CU2
Fyi: Connect #3136970 (note to self to keep track of this).