Restore problem

[seaport]

I was trying to restore a complete backup (of two months ago) of a database into a new database (with a different name) on the same SQL Server 2000.

I got the message "The log in the backup set begins at LSN 368..., which is too late to apply to the database. An earlier log backup that includes LSN 344... can be restored. RESTORE LOG is terminating abnormally."

I tried restoring the database with other selection of backup files (complete backup files and differential backup files), but got similar message.

However, when I tried restored the complete backup file to another SQL server 2000, it went through successfully.

Did I do anything wrong?

Thanks in advance.

Seaport

 

[nigelrivett]

The error message indicates that you are missing a log file to restore. i.e. there are missing transactions between the database backup and the log file (or maybe a missing log file in the sequence).

Without knokwing more about what you have and how you are trying to apply it it's difficult to say what the problem might be.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.