I am trying to understand why a differential backup finds changes when
none of the user tables has had any data inserted/updated/deleted nor
any functions/sps/views etc have been created/modified. If the database
is only being queried, what objects change?

Thanks

Perhaps some background process deleting ghost records, for instance?
Or some job, you didn't think about, modifying data? Is the diff
backup large? You should always expect some meta-data...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"timo" <timo (AT) thatsmy (DOT) biz> wrote

What about reindexing processes? They certainly will make changes that need
to be backed up.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"timo" <timo (AT) thatsmy (DOT) biz> wrote