Deleting old Maintenance plans fails

• moorthy.jy

  SSCommitted

  Points: 1753

  More actions

  August 5, 2009 at 2:23 am

  #140565

  Hi,

  We have a server migrated from SQL 2000. All the maintenace plans moved to new server. Since, its from old server, i want to delete the plans and create new ones. When i tried to delete, got this error

  Exception has been thrown by the target of an invocation (mscorlib)

  Login failed for user 'sa' (Microsoft SQL server, Error 18456)

  Login SA was not imported from the old server. I tried changing the MP owner to sa / administrative user, still failed to delete.

  UPDATE

  [msdb].[dbo].[sysdtspackages90]

  SET

  [ownersid] = 0x01--sa user

  WHERE

  [name] = 'abcd'

  Can anyone guide me to delete this?

  Thanks in advance.

  Moorthy

• MartinSchmidt

  Mr or Mrs. 500

  Points: 525

  More actions

  August 5, 2009 at 8:35 am

  #1034827

  all maintenance plan data is stored in MSDB - you can delete them from there.

  Hopefully this query can guide you in the right direction :

  select *

  from msdb.dbo.sysdbmaintplans

  /mSc