I would like to create a functionality in my program to save current database state and be able to restore it in future. I would also like to be able, if I go back to some state from, let's say 2 days ago, to return to a state from today. I was thinking about restoring a database from a transaction log (everytime I want to save the state I commit a mareked transaction (on some insignificant data)). Is it possible at all, using this solution to restore some earlier state and after that be able to restore a more recent state, or would I lost it after the restore (or they would disappear form transaction log)?
Database snapshots ?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With