I had a similar concern....
Backing up the database does not flush the transaction log and thus does not break the chain of transaction log files?
Basically, it sounds like people are saying that if transaction logs are done hourly, a backup file combined with transaction log files dated after the backup can restore to a point in time- whether or not there was another more recent full backup done in the meantime. Correct?
Creating more than one (full or differential ) backup file per day does not break the chain of hourly transaction logs. Right?
We have hourly transaction logs with a nightly full native sql backup. I wanted to do a sql lite speed compressed backup during the day. Just wondered if I would still be able to use our native nightly backup combined with hourly transaction logs for a restore to point in time, or if I would have to use the most recent backup which would be the compressed backup plus transaction logs since the compressed backup.