can someone explain this error message...

randyv

Hello -

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.

petey

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.