Hi, I am in the process of writing some backup and recovery procedures for
our SQL Server system and have run into the following problem:

I have been testing the recovery of the msdb database and have had
no luck recovering the full database.

To test the full backup and recovery, I have performed a backup of the msdb database, made
a change (ie. add a task) and then performed an incremental backup.

Following this, I will manually delete the database or shutdown the server and rename
the msdb data device.

I am able to recreate the database and load the database dump, but upon trying
to load the transaction log, I get an error saying that the transaction log dump is out
of sequence. Restart from initial load. This error continues to occur and I have repeated
this process many times.

I was able to restore this database (database dump and transaction log) to another database
named 'test' and then rename it to 'msdb' . This is the only way I have been
able to sucessfully recreate the full msdb database.

I have not been able to find any documentation regarding this and was wondering
if there is a set of procedures around restoring the msdb database after a failure?

Thanks in Advance!

Jason