Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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.

1 vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

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.

1 comment

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base