Many thanks Perry - I got brave & trashed the lot and I'm in the process of setting up LS for > 40 databases now - seems OK so far.

I'm tempted but I wanted confirmation that I won't be causing any irreparable damage before I do it - hence the original question. I know; I'm a wuss! 🙂

Thanks for this - it worked to an extent; however I still have lots of histories with agentIds that don't exist in the primary/secondary tables

I have a maintenance plan that deletes backup histories

Many thanks - I can see the sense in using a temporary table. Unfortunately I'm away for a few days but I'll try this out when I get back

Works like a charm! Thank you so much.

A.

OK - I should have read the manual. getting the database name is easy.

Now I'd like to refine my very crude script to automatically skip a database if the...