Maintenance plan - can''t find my database within the drop down window

• pmiller

  Ten Centuries

  Points: 1190

  More actions

  September 20, 2006 at 11:20 am

  #170281

  The db was originally 6.5 which was upgrade to 7.0 several years ago . I upgrade to 2K5 and changed the compatibility level to 7.

  The maintenance plan to do a backup cannot see the db - why

  all of the other databases can be seen.

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  September 20, 2006 at 11:39 am

  #661561

  Hello Miller,

  The compatibility level for 2K5 is 9 and not 7. Please check the compatibility level of other databases which were showing up in the maintenance plan.

  Thanks

   

  
  Lucky

• pmiller

  Ten Centuries

  Points: 1190

  More actions

  September 20, 2006 at 12:15 pm

  #661569

  Hi Lucky

  I changed the compactibility level to 90 and now I can see it

  in the drop down list. Why I changed it to 70 and not 90 in the first place is beyond me - thanks