DB Maintenance plan

• Kiran P

  SSC Enthusiast

  Points: 129

  More actions

  December 6, 2005 at 11:26 pm

  #170027

  Hi there,

  Does anyone know any specific reason for a database not to be a part of the Maintenance plan? Recently, I created a database and restored the data file from a backup. For some reason, I had to restore a very old copy from TSM. Now what happens is, my DB Maintenance plan has two databases by same name. It involves the old database but doesn't involve the latest one. Though I check the latest database manually, the check mark disappears by the next morning when I come and check the plan.

  I know, it's totally confusing. Any ideas would be appreciated.

  Future belongs to those who believe in the beauty of their dreams

• December 9, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Joseph Mulhall

  SSCarpal Tunnel

  Points: 4672

  More actions

  December 9, 2005 at 8:53 am

  #608694

  Change the plan, immediately go back in and verify that the change has been saved.

  If not, you don't have the right permissions.