Hi,

I wonder if someone could help. I have a SQL 2005 Server with a database running in Sql 7.0 Comp Level. I have two jobs running for backups. 1 job will perform a full DB backup at 00:00, the other job will backup the transaction logs every hour from 01:00.

For now, both jobs are appending to the media.

The issue I have is that when I come to restore a database, I can pick the initial full backup to restore from, but then when I come to restore the transaction logs, I pick the transaction log file, it lists ALL the log backups from the current day and previous days. However, I cannot pick individual transaction log entries to restore, it always want to start from the beginning of the file. This doesn't work as it is trying to restore logs that are from before my Full backup.

Is there a way round this?

Thanks for your help.

Graham

However, I cannot pick individual transaction log entries to restore, it always want to start from the beginning of the file.

Hello Graham,

a Transaction log backup includes all changes since the last full / log backup, therefore you can not restore an "individual" log backup, you always have to restore the whole backup chain.