Post reply

Maintenance clenup task not deleting bak and trn files

  • October 8, 2008 at 1:33 pm

    #124090

    Well i am using sql server 2005 64 bit edition with service pack 2( version 9.00.3050.00)

    I want to delete backups that are 2 days old, when i create a task using SSIS maintenance cleanup task it is not deleting older files. But it can delete whole trn file.

    I am really confused.

    Is their any way to resolve this.

  • October 8, 2008 at 2:26 pm

    #882569

    Did you use the SQL Server builtin Management -> Maintenance Plans -> Wizard?

    or SSIS?

    There is a "Maintenance Cleanup Task" you can check

    The Maintenance Cleanup task removes files left over from executing a maintenance plan.

    You can specify # of days/weeks old files get deleted

    Folder, Extension, Include first-level subfolder

    This should be applicable for both 2005 and 2008, looks like this

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • October 8, 2008 at 3:31 pm

    #882614

    this is most likely a bug. there have been lots of problems with cleanup tasks in maintenance plans in SQL 2005. You want to be at least at version 9.00.3054 (GDR2), but with the time thats gone by I would look at least Cumulative Update 5. (there still appears to be problems of this sort in CU4, which were re-introduced.)

    ---------------------------------------------------------------------

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply