Is there a way to track trigger fire history or which tables are changing (DML statements) on a daily basis?
Currently trying to troubleshoot an offsite backup issue where the database is changing 18-20% a day. The database is rather large and the backups are not completing in the proper time-frame. Trying to find out where all of the database change is occurring. Database size is not growing, there is just a high percentage of change per day.
Tried doing some joins on sys.tables, syscomments, sys.triggers, but there are no timestamps relevant to what I am looking for.