back up log RIGHT before full backup
We run full backups each Sunday on 2000 databases, TLOG backups every weeknight at 6pm. I thought I could restore to any point in time with this model, but it came to my attention this week that i can not restore to any point in time in the window between the Friday TLOG backup and the Sunday full. Or at least the SQB GUI will not let me restore to any such point.
When i tried to restore to Saturday at 7.45p, my options were:
Friday log 6pm or earlier
Sunday Full 4AM
Monday TLOG any time after Sunday 4AM
Seems like there should be a configuration or job so that I can backup the TLOG immediately before the FULL backup, thereby creating 6 logs a week but letting me restore to any point. Possible?