Thanks this worked brilliantly for me . It has saved me much time and I now understand a bit more about vbs. 🙂

I have put this script into the last job step on my backup job in sql2005 .

select type as activeXscript and language vb script and it runs !

Lovely job

Thanks again

Lizzy