Restore of Transaction

Hi
I am trying to restore my transaction log backup, I restored the database fr
om nights backup and trying to restore the transaction log backup which i ca
rried out immediately after the full backup, It shoots me the error below..a
ny comments
The log in this backup set begins at LSN 113294000001538200001, which is too
late to apply to the database. An earlier log backup that includes LSN 1129
37000001085700001 can be restored.When you perform the restore of your database, ensure that you mark the
"Leave database nonoperational but able to restore additional transaction
logs" option from the Options tab in the Restore Database screens.
You should then be able to apply your log.
Backup Notes:
When you perform a backup of the database, the backup backs up the database
as well as any transactions that were occurring during the backup process.
When you restore that database and select the default option of leave
database operational, it will restore the data and then roll forward
committed transactions that were part of the backup I described in the
previous paragraph.
When you restore the database and choose the option to leave the db
nonoperational, then you can restore your transaction logs.
The reason this is important is that after performing a database backup and
then performing a log backup, you will have some duplicate transactions in
both backups. To avoid running the same transactions twice, you need to do
your recovery in the appropriate order.
HTH
Rick Sawtell (co-author Teach Yourself Microsoft SQL Server in 21 days)
MCT, MCSD, MCDBA
"Rodger" <Rodger@.discussions.microsoft.com> wrote in message
news:5503FFA6-3545-4D44-9A56-94C3EE83BF49@.microsoft.com...
> Hi
> I am trying to restore my transaction log backup, I restored the database
from nights backup and trying to restore the transaction log backup which i
carried out immediately after the full backup, It shoots me the error
below..any comments
> The log in this backup set begins at LSN 113294000001538200001, which is
too late to apply to the database. An earlier log backup that includes LSN
112937000001085700001 can be restored.