question

Rahul avatar image
Rahul asked

SQL maintainance plan

Dear All,

Not able to create sql maintainance log backup plan due to fllowing error.

Microsoft SQL Server Management Studio

Cannot show requested dialog.

ADDITIONAL INFORMATION: Unable to execute requested command.

Could not load type 'Microsoft.SqlServer.Management.DatabaseMaintenance.JobScheduleDataCreator' from assembly 'Microsoft.SqlServer.MaintenancePlanTasksUI, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. (Microsoft.SqlServer.Management.MaintenancePlanWizard)

.

Microsoft SQL Server Management Studio

Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI)

sqlmaintenance-plans
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered

You dont give any details of the versions you have installed but here are a few links that might help you:

Conflicting versions of software needing registry change to resolve:
http://support.microsoft.com/kb/922214

requirement to service pack software:
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d659a1e3-a493-4d20-a8dd-226720e78503

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.