We have set up log shipping between two instances, and configured the log shipping job steps with @flags=12 (Log to table, Include step output in history). However, we have noticed that after a short period of time, the flags are reset to zero, and have to be manually configured again.
We have made other amendments to the log shipping jobs (such as adding additional monitoring steps), but these do not appear to be affected.
Is this a known issue? We've not seen it occur on other instances on the same build.
Both instances are running:
Microsoft SQL Server 2016 (SP2-CU4) (KB4464106) - 13.0.5233.0 (X64)
Nov 3 2018 00:01:54
Copyright (c) Microsoft Corporation
Web Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)