Log shipping error
With SQL-BACKUP LOGSHIPPING I have problems. I am getting errors at the standbye server side, see below.
After analysing the problem my conclusion is that all the transaction logs are saved locally, but the COPYTO command failed now and then.
How can we fix this?
Backup transactionlog job:
C:\Program Files\Red Gate\SQL Backup\SQLBackupC" -sql "BACKUP LOG wpisystem TO DISK = ''D:\SQL Data\tlogs_backup\<AUTO>'' WITH COPYTO = ''\\728PRPRINS1\tlogs_restore\''"
Error message restore transactionlog:
Msg 4305, Level 16, State 1, Server 728PRPRINS1, Line 1
The log in this backup set begins at LSN 170000000041900001, which is too late to apply to the database. An earlier log
backup that includes LSN 161000000080300001 can be restored.
Msg 3013, Level 16, State 1, Server 728PRPRINS1, Line 1
RESTORE LOG is terminating abnormally.