Post reply

Manitance DB Plan issue on SS 2005

  • February 12, 2009 at 10:53 am

    #199925

    Hello EveryOne,

    I have created a DB Maintance Place on SQL SERVER 2005 and added task to cleanup(Maintance and History) the maintance plan (Only retain 2 Days bkp). But The Bkp Runs fine but does not clean up the bkp due to some issue.

    I tried by creating as per Wizard and manually the DB Plans. But No Clue

    why?

    Can Anyone help me on this..

    Thanks in Advance

  • February 12, 2009 at 12:24 pm

    #943100

    Do you have backup files older than 2 days in that directory?

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • February 12, 2009 at 1:09 pm

    #943133

    you can profile this and see the command being run, along with the dates passed in for removing files.

    Often someone expects 2 days to mean 2 backups and they might not be the same thing.

  • February 12, 2009 at 2:33 pm

    #943209

    wasnt there an issue with maintenance plans not cleaning up?

    what version sql server do you have?

    to get your version use

    select serverproperty('productversion')

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 13, 2009 at 10:45 am

    #943797

    Thanks for all the suggestions.

    Let me answer each of you:

    1.)Do you have backup files older than 2 days in that directory?

    Yes. The log says sucess.But not deleting

    2.)you can profile this and see the command being run, along with the dates passed in for removing files.

    I can do that, but even i find that its not purging the old bkp.Then still i am left with the same question.

    3.)

    wasnt there an issue with maintenance plans not cleaning up?

    what version sql server do you have?

    The version is --

    9.00.3068.00 (sp2)

    Appericiate your support for few more suggestions

    Thanks..

  • February 14, 2009 at 11:43 am

    #944124

    gaganks (2/13/2009)

    The version is --

    9.00.3068.00 (sp2)

    Appericiate your support for few more suggestions

    Thanks..

    as far as i recall that version should be fine. Double check the delete task

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 5 (of 5 total)

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