Mike,

Take a look at Re: DBMP Remove files older than SQL 2000 Thread #1010183 Message #1010219

>I am attempting to discover the current backup schedule for some databases (databii?) on SQL Server 2000. I am finding conflicting information however, and was hoping somebody could point me in the right direction.
>
>For example, when I go to the Management folder and look in the Database Maintenance Plans and view the plan for the database, the plan says it runs a complete backup every day at a certain time. When I look at the taskpad of the database it says the last database backup was 5/29/2006 at 12:01:01 PM. When I view the actual backup files in the directory they agree with the taskpad. I click on the only Maintenance Plan link on the taskpad, and it takes me to the first plan I mentions that says every day, but if that is the only maintnenace plan, why does the last backup date on the taskpad say so long ago?
>