I need some help with a backup policy.
I've got a 153GB database.
I need to recover data if there is data loss at least for the passed hour.
Is there anyway to do it without backing up 153GB every hour?
I assume there is something with the transaction log that can be done.
If so, how can I recover the data of the passed hour from it?
Thanks in advance.
PS: sorry about my english.