I chose:
connection: local server connection
type: backup files
search files based on an extension
path to files
ext = bak
Delete files older than 4 weeks.
I run it and it never removes any of the files--what gives.What version on SQL you are using. IF you have installed SQL2005 SP2 before march 6th, then there is a know bug on cleanup task. You can download the latest SP2 build and install.
|||
This problem has been fixed in the latest Cumulative Update. Call MS Customer Service and ask for the SQL Server cumulative update. There is no charge for this service.
jkh
sql
No comments:
Post a Comment