I have database 1 and database 2 on SQLServer2014. Database 2 is a complete backup of database 2.
Every day I would like to restore on database 2 only a part of the transactions performed during the day on database 1 (for example I need all transactions from 8.00 to 12.00).
There is a way to identify all transactions made during that time and restore them on database 2?
Do you have any other suggestions for doing this?
This can achieved by doing the partial backups Please take a look at the below links it may help
https://sqlbak.com/blog/back-up-files-filegroups
Another helpful link on same note https://sqlbak.com/academy/partial-backup