Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: -delbkups not working for SQL 2000

    Hello,

    In our maintenance plan for SQL Server 2000, we are performing full backups which in turn has their retention setting to 2 days. Unfortunately, it appears that this option is not working. Has anybody else seen this? We are running on Windows 2000 Advanced Server.

    -LIONSPARC

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Have you changes the path...have you looked in the job history, what about the error logs...

    maybe try and disable it, and create a new one...

    Never had a problem with it...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Posts
    3
    We are thinking long the lines of...

    Microsoft Knowledge Base Article - 278667
    BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or ME Computers

    But I will first try re-creating the maintenance plan.

    -lionsparc

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    WIN2k Advanced server?

    I would highly doubt it...MS might as well fold there tent, hide the snake oil and close up the 3 card montee game now...

    oooppps didn't mean that they don't make a decent product....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jan 2004
    Posts
    3
    We're LOL on that one. I will let you know how we make out. One thing that is interesting is that we "changed" the maintenance plan to remove files 2 days+ old. So the original didn't have it. However, we did check the job history and appears the -delbckups 2DAYS isn't showing anything in the log. We see "delete old text files" but that's it. Do you know how it should show in the history? Thanks!

    -LIONSPARC

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I can't find any messaging indicating the delets...just the maint logs..nothing there...

    As an alternative...you can create your own sprocs to take care of this...

    And create any logging you want...very customizable...

    good luck
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •