January 12, 2010 at 10:53 pm
Good day
I have a problem restoring logs on a standby databse. One of the trn files restores but I am unable to move on to the next trn file. If I then restore the same trn file it just redo the restore.
This is the script and output. You will see I restore the same file first and last.
script
RESTORE LOG [JDE_PRODUCTION] FROM
DISK = N'J:\Logshipping\JDE_PRODUCTION_20100112083907.trn'
WITH FILE = 1,
STANDBY = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ROLLBACK_UNDO_JDE_PRODUCTION.BAK',
NOUNLOAD, STATS = 10
go
RESTORE LOG [JDE_PRODUCTION] FROM
DISK = N'J:\Logshipping\JDE_PRODUCTION_20100112090000.trn'
WITH FILE = 1,
STANDBY = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ROLLBACK_UNDO_JDE_PRODUCTION.BAK',
NOUNLOAD, STATS = 10
go
RESTORE LOG [JDE_PRODUCTION] FROM
DISK = N'J:\Logshipping\JDE_PRODUCTION_20100112083907.trn'
WITH FILE = 1,
STANDBY = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ROLLBACK_UNDO_JDE_PRODUCTION.BAK',
NOUNLOAD, STATS = 10
output
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
RESTORE LOG successfully processed 0 pages in 0.927 seconds (0.000 MB/sec).
Msg 4305, Level 16, State 1, Line 1
The log in this backup set begins at LSN 641613000005725500001, which is too recent to apply to the database. An earlier log backup that includes LSN 641613000005634000001 can be restored.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
RESTORE LOG successfully processed 0 pages in 0.892 seconds (0.000 MB/sec).
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
January 12, 2010 at 11:59 pm
Looks like there is a missing log backup file prior to JDE_PRODUCTION_20100112090000.trn
January 13, 2010 at 12:05 am
That was my first thought aswell. I did check it again and there is no missing log file. Why is the system alowing me te redo a restore that was done already?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
January 14, 2010 at 8:03 am
tvantonder-992012 (1/13/2010)
That was my first thought aswell. I did check it again and there is no missing log file. Why is the system alowing me te redo a restore that was done already?
Is any other transaction log backup taken manually or by other process?
January 14, 2010 at 10:11 pm
It is sorted. There was a problem with the copy of the file. Recopied the file and all ok now.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply