Backup TRN file issue

Hi at all, i'm new of this NG :=)
My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
trn but SQL doesn't delete the TRN files "older than x days" while it
deletes the other older file, so it make my disk full in a few days...
There is a patch for this?
I checked the parameters of the job and they are correct...
Any solutions?
Many thanksHi
The file is only deleted xx days after you specify, but the same Maintenance
Wizard need to run to do it.
e.g.
Full Backup on 1 January 2005 with setting of delete after 5 days (5x24
hours, no 5 actual days).
The same job only runs again on 7 January 2005. The file will only get
removed on 7 January as that is when the same job runs again.
If the job was run on 5 January, the file would get deleted, and as long as
the job runs at the same time, or slightly later.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Macchianera" <424invalid@.mynewsgate.net> wrote in message
news:20050923094911424@.mynewsgate.net...
> Hi at all, i'm new of this NG :=)
> My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and
> trn but SQL doesn't delete the TRN files "older than x days" while it
> deletes the other older file, so it make my disk full in a few days...
> There is a patch for this?
> I checked the parameters of the job and they are correct...
> Any solutions?
> Many thanks
>