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
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 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
Sign in with: oidc
Signed in as (Sign out)

Feedback and Knowledge Base