CODEWITHSUNDEEP
sql-servertransaction-log
xc93hil
xc93hil

Reputation: 105

Partial recovery SQLServer transaction log

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?

Upvotes: 0

Views: 181

Answers (1)

HarishM-AIS
HarishM-AIS

Reputation: 46

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

Upvotes: 0

Related Questions