Post reply

issue with backup cleanup step

  • August 28, 2023 at 6:27 pm

    #4273946

    I have a maintenance plan for my nightly backups.  It consists of three steps:

    1.  Back up my databases to a folder on another server - in this case it's literally just a Windows server with a lot of drive space.
    2.  Run DBCC check db against my databases.
    3.  Cleanup - delete any backups older than five days.

    A few weeks ago, we changed the sa password on the server.  Since then, the cleanup step has stopped working.  I've tried deleting and recreating the step (but not the whole job) and it still doesn't work.  No errors or anything else unusual in the logs or the job history; it just doesn't actually delete any backups.  I don't think it actually uses the sa account by the way - it's using NT integrated security - but the timing seems suspect.

    Oddy enough, I created a brand new maintenance plan that *only* does the cleanup step, and it works as expected.

    Ideas?

  • August 28, 2023 at 7:20 pm

    #4274001

    cphite wrote:

    Ideas?

    Stop using maintenance plans - they have too many 'features'.

    Try:

    https://ola.hallengren.com/

    or:

    https://www.minionware.net/products/backup/

     

  • August 28, 2023 at 9:25 pm

    #4274062

    There's likely some security issue. The plan can't run itself. Possibly the job that runs it uses the sa account, or it's buried in the config.

  • August 29, 2023 at 5:28 am

    This was removed by the editor as SPAM

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

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