Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Discovering current backup schedules
Message
From
08/06/2006 09:51:12
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Discovering current backup schedules
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01127821
Message ID:
01127821
Views:
67
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
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform