I am trying to set up log shipping between two servers. The secondary database is Read-Only. Everything seems to be working fine for a short time. The transaction log is backed up every 5 minutes and i can see the .trn files in the file share on the primary server.
The copy and restore jobs on the secondary servers do not seem to be working. The copy job is reporting as successful and the duration recorded for the copying is either 0 or 1 seconds in the job history.
However, as soon as the threshold is met, the monitor reports that the secondary server is out-of-sync.
Anyone know why the copy job isn't working correctly? Anyone come across this problem before and know how to resolve it?