Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Cleveland, OH
    Posts
    12

    Angry Unanswered: Weird problem with Database Maintenance Plan....

    Weird problem with Database Maintenance Plan....

    I will mention this problem I am having with one our servers. This server has several databases and four maintenance plans that schedule the backup, integrity and optimizations.

    Now for only one of these plans, the rest of the plans are identical, on this server when I select the option "Perform these tests before backing up the database or transaction log" in the "Integrity" tab and save it, it does not stay selected. By that I mean, if I go back to the maintenance plan properities and check if the option is selected, it shows that it is not. While I had just selected the option a moment ago and saved it.

    I realized this when the integrity jobs did not run before the backups as they used to. So, somehow this option got unselected and cannot be selected anymore.

    On another server, there are three maintenance plans and all of them have the same problem. No matter what I do, I cannot save the plan with that option.

    To give you guys some background, I already SP3 applied to all these SQL2000 servers running on Windows 2000. Also, these plans used to work fine before. For sometime, I have had some problems like these with my local installation of SQL server but not on our production boxes. Now it seems like the problem has propogated to them too.

    Has anyone come across anything like this. Any help or direction would be appreciated. Thanks in advance.

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    I've seen some weird problems with maint plans like this before, only solution I came up with was to create a new maintenance plan.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Oct 2003
    Location
    Cleveland, OH
    Posts
    12
    I tried that, it did not work.

    I think I can add one more thing about the maintenance plans. If I delete a maintenance plan, the related jobs created by this plan do not get deleted!!!!

    So, I did that with my problematice maint. plans. Deleted the plans and then deleted the related jobs. Created a new plan......with the same problem.

    I don't know what to do.

  4. #4
    Join Date
    Oct 2003
    Location
    Cleveland, OH
    Posts
    12
    Well, I found a solution. I modidied the Jobs associated with the Maintenance Plans, directly by adding the options '-BkUpOnlyIfClean -CkDB ' to the xp_SQLMaint command. Even the associated Maintenance Plan showed the appropriate option selected.

    Thanks for taking time to answer my question.

Posting Permissions

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