dusty_machines

I’ve been trying to set up log shipping between two boxes running Sql Server 2000 - but everytime I got to the last step, I’d get the above error.

This is actually really simple to fix! On a previous attempt, running the Log Shipping wizard, the wizard had finished uncleanly, not rolled back entirely, and had left a row in the  log_shipping_monitor table of msdb, a system database which comes with Sql Server 2000.

Check that table now! Is there a row there? Delete it and re-run the wizard, you should have gotten rid of the above error.