Neil,

>The full database restore completes successfully, but when I try to restore
>the first transaction log backup, I receive the following error message:
..
>SQL Status: DB-LIB message: This backup set cannot be restored because
>the database has not been rolled forward far enough. You must first restore all
>earlier logs before restoring this log.

Is this a SQL 7 server?  If so, when you did the full backup, did you truncate
the logs?  SQL 7 changed the function
of a "full" backup to include only that portion of the transaction log necessary
to get a consistent DB image (rather than everything in the transaction log as
it was in prior releases) .  So, with SQL 7, you should follow a full backup by
an incremental before truncating the logs to ensure that you capture all the
transaction log data.  Otherwise, you may have a gap in the transaction logs
resulting in the error you are seeing on restore.

Chris Zaremba
ADSM Agent Development
internet  zaremba AT us.ibm DOT com