Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Discovering current backup schedules
Message
De
08/06/2006 09:51:12
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
Discovering current backup schedules
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01127821
Message ID:
01127821
Vues:
70
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/
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform