locked
MAINTENANCE PLAN RRS feed

  • Question

  • Hi all,

    Can we cleanup the compressed zip files of bak files of a database  using the cleanup task .I have given the extension as .zip in the plan wizard but it did not work. 

    any advice,

    chinna.

    Friday, March 8, 2013 4:14 PM

Answers

  • Hi All I have found a solution 

    http://beyondrelational.com/modules/2/blogs/88/posts/10184/ssis-delete-files-older-than-retention-period-from-specified-folder-using-script-task-in-sql-server.aspx

    and schedule a windows job and it is working

    sql agent job is not working .

    Thank Alberto :-)

    • Marked as answer by chinna738 Wednesday, March 27, 2013 2:48 PM
    • Unmarked as answer by chinna738 Monday, April 8, 2013 12:51 PM
    • Marked as answer by chinna738 Monday, April 8, 2013 12:51 PM
    Wednesday, March 27, 2013 2:48 PM

All replies