jlandry (9/30/2014)
Would regular maintenance routines assist with this issue?
No
Could creating a backup cause this issue?
No.
so I am looking for any suggestions on how we can prevent this from happening.
Something is running update statements against those tables. Either audit with triggers, run a server side trace or configure extended events and see who and what is running those updates.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability