Hi all,

I have the following problem when I try to load back the database backup and transaction
log backup.

1. load last database backup ( it helps me to restore data and transaction log )
2. load transaction log backup ( since I have made log backup every 2 hours, so
I restore all of them, they helps me to re-execute the transaction )
3. the database is exactly what it should be
4. I backup the current state
5. After backup, I perform some transactions
6. after 2 hours, do the transaction log backup
7. I found that the it does help me backup log but it DOESN'T truncate the log
8. I even cannot truncate them by using enterprise manager. The logs seems dead
on the server

All the transactions have committed yet. I don't think they are belongs to uncommitted.
So, do you know why? Am i doing any wrong steps.

Much Thanks.