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?
Thanks for any advice,
Mike