create backup from a table if Data changes

[Sofinobi]

hello to All,

please, i'm new in SQL , and need help if you can
i have a database in SQL, i would like to create auto backup for a Customer table everytime when data changes in that table to keep the historical changes
for exemple; if the Seller or the Situation of a Customer changes , i would like to create a new row with the new information of the costumer
thank you

[#2]

This is maybe a solution?
https://learn.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ve...

[#3]

The provided informations are very less.

One way is CDC = Change Data Capture:
https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-d...