Backup question

Hi All,

I have a database backup that was taken at 10:00 pm and a transaction log backup that was taken at 12:00 pm. If I run a database backup at 2:00 pm, the transactions that are in the 12:00 pm transaction log backup will be committed to the database, and I can safely delete the 12:00 pm transaction log backup. Am I right? Thanks.See scenario below:

Monday 10PM - full db backup
Tuesday 12PM - transaction log backup
Tuesday 2PM - full db backup

The Tuesday 2PM backup contains transactions backed up at 12PM the same day. If the assumption of your explanation is correct, - then the transaction log backup is not needed if you intend to restore the full backup from 2PM.|||Would there be a situation when I want to use Monday 10PM full db backup instead of Tuesday 2PM full db backup for restore? Don't I always want to use the latest db backup?|||The transactions in your backup log are committed anyway.
A database backup is fully recoverable, and does not require prior logs.
You may STILL want to keep your logs, because they enable you to perform "point-in-time" restores, which database backups alone do not allow.|||Would there be a situation when I want to use Monday 10PM full db backup instead of Tuesday 2PM full db backup for restore? Don't I always want to use the latest db backup?
See my above response. You should keep a cycle of backups and logs to allow you to perform point-in-time data recovery. For those times when the accounting department tells you "we just found out today that we goofed up last week".