Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting old backup files
Message
De
19/07/2008 16:16:38
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01332544
Message ID:
01332548
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.
>>

Thank you very much.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform