June 13, 2007 at 12:32 pm
RESTORE
DATABASE CAN
FROM DISK = 'F:\DailyBackup\CANDIDATE_db_200706130100.BAK'
WITH NORECOVERY,
MOVE
'v3_Data' TO 'F:\Microsoft SQL Server\MSSQL$TEST\Data\can.mdf',
MOVE
'v3_Log' TO 'F:\Microsoft SQL Server\MSSQL$TEST\Data\can'
RESTORE
LOG CAN
FROM DISK = 'F:\DailyBackup\CANDIDATE_tlog_200706130200.TRN'
WITH RECOVERY
Restore full backup was successfull but not the transaction log, any ideas?
Msg 4305
, Level 16, State 0, Line 1
The
log in this backup set begins at LSN 2010000000009600001, which is too late to apply to the database.
An earlier
log backup that includes LSN 2010000000009300001 can be restored.
Msg 3013
, Level 16, State 1, Line 1
RESTORE
LOG is terminating abnormally.
RESTORE
HEADERONLY
FROM
DISK ='F:\DailyBackup\CANDIDATE_db_200706130100.BAK'
FirstLsn LastLsn CheckpointLsn DifferentialBaseLsn
2010000000009100001 2010000000009300001 2010000000009100002 2010000000008600002
RESTORE
HEADERONLY
FROM
DISK = 'F:\DailyBackup\CANDIDATE_tlog_200706130200.TRN'
FirstLsn LastLsn CheckpointLsn DifferentialBaseLsn
2010000000009600001 2010000000009600001 2010000000009100002 2010000000009100002
June 13, 2007 at 12:41 pm
It looks like you have one or more log files that need to be applied in between the full backup and the transaction log backup that you have. If you're trying to restore using this technique you need to restore your last full backup and then ALL log backups (in order) since that backup completed.
June 13, 2007 at 12:49 pm
I know that.
That is my last full backup @ 1:00 AM
Then, the transaction log backup @ 2:00 AM
June 13, 2007 at 12:51 pm
Did you do a BACKUP LOG ... WITH NO_LOG/TRUNCATE_ONLY between those times? Or maybe change the recovery model? I believe those could monkey around with the LSN's but beyond that I don't know what could've happened from the information provided.
June 13, 2007 at 2:18 pm
I used the Database Maintenance Plan Transaction Log Backup.
While the Recovery Model is Full
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply