our log shipping failed because the network link between primary and secondary is too busy for the whole day and copying a 6GB log takes 23 hours and we stop it until now, which the network is going ok, log file can be copy.
but the restore job keep failing, application log has this :
The log shipping secondary database <server>.<DB>has restore threshold of 180 minutes and is out of sync. No restore was performed for 11229 minutes. Restored latency is 63 minutes. Check agent log and logshipping monitor information.
the log retention period is 2 days, I am not sure what happened?
please share experience.
Storage SoftwareMicrosoft SQL Server 2008Microsoft SQL Server
Last Comment
marrowyung
8/22/2022 - Mon
marrowyung
ASKER
but in case we need to recreate the log shipping, can we just script out the log shipping configuration and just deploy again on primary server?
or we need to do a full backup restore again and kick off log shipping again?
and the DB doing this log shipping has merge replication setup, any concern on recreating the log shipping?
I think no as we just back that DB up and then the log shipping wizard will create the job again for us , then starting copying transaction log again?
so the steps is :
1) untick the "enable this as a primary database in a log shipping configuration " in the database properties page and let SQL server handle the job remove.
2) do full backup on primary and copy the backup to secondary and restore as non recovery mode.
3) then tick the option in 1) ?
or we need to do a full backup restore again and kick off log shipping again?
and the DB doing this log shipping has merge replication setup, any concern on recreating the log shipping?
I think no as we just back that DB up and then the log shipping wizard will create the job again for us , then starting copying transaction log again?
so the steps is :
1) untick the "enable this as a primary database in a log shipping configuration " in the database properties page and let SQL server handle the job remove.
2) do full backup on primary and copy the backup to secondary and restore as non recovery mode.
3) then tick the option in 1) ?