Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting old backup files
Message
 
 
À
19/07/2008 15:57:11
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01332544
Message ID:
01332547
Vues:
7
It's not an answer to your question but something to consider. A while back we switched our Backup from the the Database maintenance plan to the script by Nigel Rivett from http://www.nigelrivett.net/BackupAllDatabases.html because it allows better control over backup.

>I chose to backup all databases for the server daily using a subdirectory for each database. The Maintenance Cleanup task on the other hand does not have an option to delete backup files older than a certain time in the database subdirectories.
>
>Other than naming each subdirectory or placing all files in the same directory is there a way to make the delete process go into the subdirectories? I tried using an asterisk for directory name but T-SQL doesn't like it.
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform