dcsimg
Results 1 to 6 of 6

Thread: sql maintenance plan fails database missing

Hybrid View

  1. #1
    Join Date
    Feb 2010
    Posts
    1

    sql maintenance plan fails database missing

    2005 sql cluster maintenance plan created. selective dbs to backup. eventually one of these dbs is deleted without changing maintenance plan. next time it runs error in log files
    Failed0) One or more selected databases no longer exist on server. the db is deleted and there is no reference to the deleted db within the plan. the only way to get rid of this error is to rebuild a new maintenance plan.

    any ideas ?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Don't need rebuild plan, just go to backup step and choose dbs again.

  3. #3
    Join Date
    Jan 2010
    Posts
    37
    I have seen this with SQL 2000 maintenance plans, but not SQL 2005 ones. I would agree with rmaio, just go to the plan and modify the backup task and it should work.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    It happens on sql2k5 even sql2k8, plan will not change dynamically when db changes status.

  5. #5
    Join Date
    Mar 2010
    Posts
    1
    Quote Originally Posted by tbrownch View Post
    2005 sql cluster maintenance plan created. selective dbs to backup. eventually one of these dbs is deleted without changing maintenance plan. next time it runs error in log files
    Failed0) One or more selected databases no longer exist on server. the db is deleted and there is no reference to the deleted db within the plan. the only way to get rid of this error is to rebuild a new maintenance plan.

    any ideas ?
    Try a wild card.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    No such option in maintenance plan.

Tags for this Thread

Posting Permissions

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