Log shipping error
Posted on 2006-11-01
Log shipping monitor is showing wrong information, though all the jobs are getting completed successfully. It shows otherwise, I know this info is coming from log_shipping_primaries and log_shipping_secondaries tables. These tables are updated with server names but backup fields (last_update,last_backup_file) are not updated.
Yes, SELECT and UPDATE privileges have been set up to public.
It is SQL 2000 SP4 both primary & Secondary(this itself is monitoring server) servers.
I see error, Error: 14420, Severity: 16, State: 1 in log file.