Differential Backup of A Table In Sql Server I will transfer the datas of a two different table to a database in reporting server Daily but i don't want to do it manually and also don't want to transfer all the datas to that databases everyday. Instead of doing it, i wonder that if i can take full backup and then day by day differential bakcup or not? Is there a way doing this logic in sql server?
Consider using Transactional Replication

https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-replication?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-replicating-data-between-continuously-connected-servers?view=sql-server-ver15

It allows keep up-to-date copies of your tables at reporting server, without copying any other tables/data that you do not need