Comments
1 comment
-
It appears that the log file 'LOG_10.1.2.40_(local)_wfr_20070404_093001' has already been applied to the database. Try using a later log file.
Actions which may have caused this situation include:
- a recent full backup was restored, which made the need to restore earlier log files redundant
- the log file was applied, but was not moved out of the \\Whaley03\SHIPPING folder to the 'E:\EPICOR_MDF\SHIPPING\PROCESSED\' folder. You would need to check the SQL Backup logs for any warnings that were raised at the time the log file was first restored.
Add comment
Please sign in to leave a comment.
I've had log shipping turned on for about 1 month now, with no error messages.
This morning I started getting the messages for the same database, like the one below... can someone explain what this is saying?
SQL Backup log file
4/4/2007 11:40:00 AM: Restoring wfr (transaction logs) from:
\\Whaley03\SHIPPING\LOG_10.1.2.40_(local)_wfr_20070404_093001
4/4/2007 11:40:00 AM: RESTORE LOG [wfr] FROM DISK = '\\Whaley03\SHIPPING\LOG_10.1.2.40_(local)_wfr_20070404_093001' WITH NORECOVERY, MAILTO = 'rvolters@whaleyfoodservice.com', ERASEFILES = 10, FILEOPTIONS = 1, MOVETO = 'E:\EPICOR_MDF\SHIPPING\PROCESSED\'
4/4/2007 11:40:00 AM: SQL Server error
4/4/2007 11:40:00 AM: Server: Msg 3013
RESTORE LOG is terminating abnormally.
4/4/2007 11:40:00 AM: Server: Msg 4326
The log in this backup set terminates at LSN 1197000006684500001, which is too early to apply to the database. A more recent log backup that includes LSN 1200000002173500001 can be restored.