If I have Backup Pro set up (this is an example) to backup a database like this:
- Daily full backup with hourly transaction log backups
And a failure happens at 1:30pm, as I understand it, I would also need to do a "tail log" backup BEFORE restoring the full backup along with all the log backups...
1) Is this true/correct?
2) And if so, does Backup Pro do this?
3) Does the tail log backup get the the data back from 1pm-1:30pm? (The time between the last transaction log backup and the failure?)
Thanks for any info....trying to improve my understanding of this...