That really helps, thank you.

The solution was to add a step through the VB6 code. It seems that if you add a transformation through EM it creates the step automatically but not through code.

All,

Thank you for your advice regarding breaking the log chain and shrinking the log file rather than the DB. I'd realised I would break the log chain if I truncated...

All,

"Backups don't shrink the file. They just remove backed up entries within the file leaving the space available for reuse. "

That's the bit I hadn't understood. Sorry for being dumb....

Thank you for the reply. Sorry I should have stated that. It's in full mode. I assume your suggesting simple mode to check whether it's old transactions that were never...

Peso,

Thank you.

Andrew

Chris,

The first part was successful. The problem is that this happens every time I recreate the log shipping maintenance plan.

Thanks again

Andrew

Chris,

Many thanks for your reply. I did as you suggested and now the backup job on the source is telling me that it failed and the source db has not...

All,

I have now solved this by using this t-sql command.

EXEC sp_addlinkedsrvlogin 'Servername', 'false', NULL, 'Admin', NULL"

If anyone has a similar problem and wants more details please ask.

Thank you

Andrew

Apologies. Machine 1 is XP SP2.

Andrew