Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting old backup files
Message
 
 
To
19/07/2008 15:57:11
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01332544
Message ID:
01332547
Views:
8
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform