Post reply

Cleanup Task strange behaviour

  • April 24, 2007 at 5:28 am

    #116928

    Hi all,

    I created a maintenance plan with a cleanup task to delete bak files older than 4 days, but it keeps deleting everything but the current day files.

    This is the generated T-SQL:

    EXECUTE master.dbo.xp_delete_file 0,N'F:\SQLDBBACKUP',N'BAK',N'2007-04-20T11:59:30',1

    Someone can tell what's wrong with it?

    I've noticed that wheter if you put the condition on files' age or not it generates exactly the same T-SQL statement, it says that the actual one could be different if you set conditions on the task, but if it is so why they work the saem way?

    Thanks!

    Cheers,

    Giovanni

    JI

  • April 25, 2007 at 9:11 am

    #702404

    What is your version of the database? if you are below 9.00.3050 there is a bug that does not convert intervals correctly. Both the system and the servicemangement studio should be on the same service pack also.. If you are on any version of service pack2 then you must review and add kb933508 fix to the system. This solves the odd interval conversions. This could be your problem

  • April 25, 2007 at 9:23 am

    #702410

    Version is 9.00.3042.

    Probably is related to what you say.

    I'll try to install the SP2 fix.

    Thanks,

    Giovanni Idili

    JI

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

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