General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Deleting old backup files
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.
TIA,
Alex
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only