Results 1 to 6 of 6

Thread: sql maintenance plan fails database missing

  1. 02-22-2010, 09:27 AM #1
    tbrownch
    tbrownch is offline Registered User
    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 ?
    Reply With Quote Reply With Quote
  2. 02-22-2010, 03:24 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Don't need rebuild plan, just go to backup step and choose dbs again.
    Reply With Quote Reply With Quote
  3. 02-23-2010, 04:43 PM #3
    J013
    J013 is offline Registered User
    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.
    Reply With Quote Reply With Quote
  4. 02-24-2010, 08:53 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    It happens on sql2k5 even sql2k8, plan will not change dynamically when db changes status.
    Reply With Quote Reply With Quote
  5. 03-11-2010, 05:16 PM #5
    Psydotoxin8560
    Psydotoxin8560 is offline Registered User
    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.
    Reply With Quote Reply With Quote
  6. 03-12-2010, 08:48 AM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    No such option in maintenance plan.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules