The company I'm doing some work for is using log shipping to sync a production database with a secondary. Is there any way I can determine the rows that were inserted, updated or deleted after a restore is done on the secondary? Since the secondary is read-only, I cannot put triggers on any tables, enable CDC etc. on the secondary. So I'm looking for a way to know what changed after a restore.
SQL Server 2014 is being used.
LOP_DELETE_ROWS
for deletes, etc. from the backup file itself.fn_dump_dblog
- read tlog directly using undocumented function and then filter byLOP_DELETE_ROWS
etc to check for deletes. This will be learning curve for you.