Auto delete of backup files after 1 week problem

I have SQL 2000 maintenance plan setup to do full backups and have the "delete backups after 1 week" enabled but it never works. It seems to only work on the master and msdb backups but no user databases.

Any ideas?
Do you have any antivirus software installed?
What is the service pack on SQL Server?|||I think we have Trend Server Protect on all the servers.

How do I check the service pack of SQL?

Attaching a Database

Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF file
only.
Kindly guide me.
AmitCheck out sp_attach_single_file_db in the BOL.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF
file
only.
Kindly guide me.
Amit|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
--
Andrew J. Kelly SQL MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23%23J1x%23$7EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Check out sp_attach_single_file_db in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
> Hi Friends
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
> Kindly guide me.
> Amit
>