September 19, 2008 at 11:57 am
is there a way to put them both in the cleanup task or do I have to manually add another cleanup task to take care of the old trn files?
I am trying to setup my maintenance plans but I would like to put both file types in the field. An asterisk doesn't seem to work for me and I have tried putting things in like "trn,bak" or "trn bak". Anyone know what the proper thing to do here is? Am I condemned to manually adding this in after i use the wizard?
September 19, 2008 at 12:02 pm
Jason - As far as I know you are correct and you will have to add another task. I started writing an article about the xp_delete_file extended stored proc but never finished it. Anyway, the procedure is pretty picky and reviews the header record for the files that it is going to delete so, I can only assume that it uses that input of the file type to understand what kind of header record that it is validating.
Hope this helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply