Hi
We currently have Netbackup configured on our Production database and we can thereby shrink the logfile size so it does not keep growing.
We are now enabling log shipping on our primary db so that we can replicate the data to another server. We noticed that with that enabled there is backup happening via log shipping besides the netbackup scheduled earlier. so
when we try to restore the log shipping backup to other location, we get this error
2019-11-19 04:45:20.92 ***
Error: The file ‘\\LVSP10SQL001\LS_backup\Account_20191119043017.trn’ is too recent to apply to the secondary database ‘Account’.(Microsoft.SqlServer.Management.LogShipping) ***
2019-11-19 04:45:20.92 ***
Error: The log in this backup set begins at LSN 74337000001428600001, which is too recent to apply to the database. An earlier log backup that includes LSN 74337000001366400001 can be restored.
RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) **
Could you advise what are the various ways to overcome this ?
Thanks
RG