Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting old backup files
Message
From
19/07/2008 16:16:38
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01332544
Message ID:
01332548
Views:
6
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform