I am doing an analysis to check in MSSQL 2019 to confirm whether it allows to take data backup of recent changes as similar to Git.

I need to go back to older data version if there is an need. Any way to do this ?

CodePudding user response：

I can only imagine

1. backup/restore
2. log table and trigger

CodePudding user response：

Primarily you would use backup and restore database or restore with no-recovery and apply transaction log backups to get to a point-in-time restore.

There is also system versioning which has in-built support for logging changes to data in a table to capture historical changes.

Other options would be to roll your own bespoke solution using something like change tracking or change-data-capture, or even triggers for specific tables.