Post reply

Maintenance Job

  • September 11, 2008 at 9:45 am

    #212562

    I have a maintenance job that runs backups - and this been running great...but just started to just do no backups.

    I cannot see the process running in activity so i stopped it and restarted it.

    Restarted SQL Agent and the backup will not run from a job.

    I cannot see any messages or anything.

    Any ideas what to look at - will be doing a reboot but just wondering if any one had this happen before.

  • September 11, 2008 at 9:51 am

    #870432

    Anything in the error log?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 11, 2008 at 10:24 am

    #870460

    Noting in log at all.

    i ran manually the job it just sits there for ever with executing and i see nothing running or the backup started. Nothing in log .

    Oddest thing.

  • September 11, 2008 at 10:25 am

    #870462

    Nothing in the agent log, error log or job history? Is this a maintenance plan job or a custom procedure?

  • September 11, 2008 at 10:37 am

    #870471

    Its a maintenance plan for the backups databases.

    Nothing looking in any logs

    If i cancel it manually it then writes to log saying closed.

    But when running - it just says executing and it should only be 2 minutes to run but it sits for ever.

    Hmmm....

  • September 11, 2008 at 11:15 am

    #870508

    Is going to roll over my cluster and restart it - thats whats cluster is for ha...to bounce server without too much interruption

    I let you know if restarts job .

    Reboot fixed it ............i keep eye on this why just stopped interesting.

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

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