Hi,

One Dba from a client send me one TRN that he say that contain full
database.

I execute:

RESTORE DATABASE Dow
FROM Disk ='C:\.......\file.TRN'
WITH RECOVERY,
MOVE 'AspenBatch_dat1' TO 'C:\DOW_data.mdf',
MOVE 'AspenBatch_log1' TO 'C:\Dow_log.ldf'
GO

But I receive always this error:

Msg 4305, Level 16, State 1, Line 6
The log in this backup set begins at LSN 46000001073700001, which is
too recent to apply to the database. An earlier log backup that
includes LSN 45000001557400001 can be restored.
Msg 3013, Level 16, State 1, Line 6
RESTORE DATABASE is terminating abnormally.



Please !

TRN extension is used for Transaction Log Backups by default by SQL Server.
Of course this does not mean you can not name a FULL database backup's
extension as TRN, however the error you get is shown when you try to apply a
wrong Transaction Log backup according to the chain of logs.

For example let's say you have a FULL Database Backup which is called
"MyDBBackup.BAK"

And then after a while you take a Transaction Log Backup "MyTranBackup1.TRN"

And then Transaction Log Backup "MyTranBackup2.TRN"

And you wanted to restore it... First you'll need to restore the Full
Database Backup which is "MyDBBackup.BAK" in this scenario and then you
should restore the first Transaction Log backup which was taken after the
Full Backup "MyTranBackup1.TRN" and then you should restore
"MyTranBackup2.TRN".

If you restore the "MyTranBackup2.TRN" before "MyTranBackup1.TRN" then you
get the exactly the same error message you get below... (except for the LSN
numbers... They'll be different)

--
Ekrem Önsoy



"Camacho" <pmcamacho@gmail.com> wrote in message
news:868a7273-806b-4be3-a104-a28824fbc934@m44g2000hsc.googlegroups.com...
> Hi,
>
> One Dba from a client send me one TRN that he say that contain full
> database.
>
> I execute:
>
> RESTORE DATABASE Dow
> FROM Disk ='C:\.......\file.TRN'
> WITH RECOVERY,
> MOVE 'AspenBatch_dat1' TO 'C:\DOW_data.mdf',
> MOVE 'AspenBatch_log1' TO 'C:\Dow_log.ldf'
> GO
>
> But I receive always this error:
>
> Msg 4305, Level 16, State 1, Line 6
> The log in this backup set begins at LSN 46000001073700001, which is
> too recent to apply to the database. An earlier log backup that
> includes LSN 45000001557400001 can be restored.
> Msg 3013, Level 16, State 1, Line 6
> RESTORE DATABASE is terminating abnormally.
>
>
>
> Please !
>