Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    10

    Unanswered: maintenance plan problems

    hello all -

    I have a maintenance plan, first optimizes, then checks integrity, then does database and log backups then writes to the system log.

    All the jobs fail and I cannot figure out why.

    All jobs are logged in with sa, proper password, yet the jobs fail.

    Can anyone give me any ideas why? If you need any logs posted, let me know and thanks.
    randyvol
    <>< "what we do in life echoes in eternity"

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: maintenance plan problems

    Can you give us an idea what happened other than it failed?

  3. #3
    Join Date
    Dec 2003
    Posts
    10

    Re: maintenance plan problems

    Originally posted by joejcheng
    Can you give us an idea what happened other than it failed?
    Well, I can give you exactly what happened - I had a brain cramp and set the plan to backup ALL databases. Which means that the job tried to perform maintenance on MASTER and MSDB in non single user mode, which flagged out as a failure. Hence, the jobs showed failed when actually after investigation, I find that all the databases are being maintained properly except the System DBs which cannot be maintained in this mode.

    Ergo, I need to fix the plan and just maintain non System DBs.

    Duh.

    Thanks anyway, asking the question made me investigate. I just assumed I had done something wrong creating the plan (which technically I did).
    randyvol
    <>< "what we do in life echoes in eternity"

Posting Permissions

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