SEO

#1 (**permalink**) 02-29-2008, 02:38 AM

I have my Sql 2000 maintenance plan set to back up and then remove .bak and
..trn files after 4 days. It removes .bak fine, but not the .trn for some
reason. This is ok for a while, but adventually it fills up the drive. I
tried deleting and recreating the maint plan, but that didn't help. Any
ideas?

Thanks,

Greg

#2 (**permalink**) 02-29-2008, 02:39 AM

"GregB369" <gregb369@yahoo.com> wrote in message news:<108vs6i6ajtbs6c@corp.supernews.com>...
> I have my Sql 2000 maintenance plan set to back up and then remove .bak and
> .trn files after 4 days. It removes .bak fine, but not the .trn for some
> reason. This is ok for a while, but adventually it fills up the drive. I
> tried deleting and recreating the maint plan, but that didn't help. Any
> ideas?
>
> Thanks,
>
> Greg

This KB article may be helpful:

http://support.microsoft.com/default...;en-us;Q303292

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Sql maint plan not removing .trn files