Maintenance Plan Wizard is Crashing

Hi,

I am having trouble with the Maintenance Plan Wizard in SQL Server 2005 Management Studio.

I have run the Maintenance Plan Wizard many times since I installed SQL Server 2005. However it looks like there is a problem with assembly 'Microsoft.SqlServer.Smo. I am getting this error:

- Creating maintenance plan "DNNSRC Backup" (Error)
Messages
* Create maintenance plan failed.

ADDITIONAL INFORMATION:
Could not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. (Microsoft.SqlServer.MaintenancePlanTasks)

Note I was going to upgrade with service pack 2 but I am reluctant to do that until I fix this problem. I am not sure SP2 would have any effect.

Any help or suggestions would be very much appreciated.

Thanks.
G. M.

make sure that your system is upgraded to SP2 and also you have installed SSIS.

Refer these links for more info

http://support.microsoft.com/default.aspx/kb/933508

http://blogs.msdn.com/sqlrem/

Madhu

|||

Check the following thread...sp2 resolve the same issue...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1404000&SiteID=1

|||Thanks, Your suggestions helped. I installed SP2 and that corrected the problem.