No Description - Modify Backup Maintenance Plan failes to save.

Question

Hello,

 

SS2k5 - 9.00.3050 (x64) - Most current SP

 

I've created a backup maintenance plan 'All User Databases'.  Plan saved and executes.

 

Modify plan to add new subplan step to remove old backup files, save fails with a Studio Dialog encapsulating the message  ->  No Description

 

Cannot save the Maintenance Plan.

 

Any ideas about how to save the Plan?

 

Thank You...  Covi

 

Answer 1

Covi, I ran into something similar lately.  My laptop has SQL 2005 with SP2, the servers had SP0 or SP1.  I was creating/maintaining maint plans for the servers ON my laptop.  So it was using SP2 software... different then SP0 or SP1.  Just guessing, but is it possible you have the opposite situation?  and the server is SP2 and your laptop where you run Studio to update the plan is SP0 or SP1?  I learned to remote into the server with SQL on it and use the clinet tools on the server until we get everything at the same SP.  Then all was ok.  Bruce

Answer 2

Thanks Bruce for taking time to reply.  I applied SP2 to my Notebook implementation of SS Mgt Studio.

 

SQL2005 SP2 on Notebook and Server.

 

Server: 64 Bit

Note Book: 32 Bit

 

Maintenance Plan access from Notebook to Server - Failes

 

MS SS Mgt Studio Error Dialog

    Msg: Value Cannot Be Null

               Parameter Name: component(System.Design)

  

XML Error -  Error Loading from XML  blah blah vlah

 

In essence I am unable to update Maintenance Plans on a 64Bit SQL Server from a 32 Bit Studio.  Bummer Dude!

I can maintain (simple changes) to 32 bit maintenance plans. 

 

Maintenance Plan access on local 64 Server

 

Problem still exists,

 

On SQL Server 2005 SP2 64Bit - Cannot save existing Maintenance Plan.  SimplyOpen and Save, fails with 'NO Description' dialog.

 

 

 

 

Answer 3

I'm having the same exact problem.  A coworker was able to save the same Maint Plan though, but I have yet to compare our XML dlls.  We're both using SQL2005 SP2 workstations administering SP2 64-bit instances.

Answer 4

Hello people,

 

To solve your issue, go to http://support.microsoft.com/kb/922546/en-us

 

Subject is: "...No description found" error message when you create an SSIS package or a SQL Server maintenance plan in SQL Server 2005"

 

Take a look for the WORKAROUND in this section.

 

Regards,

 

fjandrad

Answer 5

I fought with problem too and finally found the solution - by accident.   I lost the ability to drag and drop attachments from Outlook and went looking for a solution.  I found it and fixed both problems.

Execute this:
regsvr32.exe ole32.dll

Answer 6

Great job sqldoc, kudos to you friend.  You fixed the problem for me...and I assume everyone else here.  Well done!

Answer 7

Brilliant solution sqldoc, this issue was driving me mad for a few days and finally stumbled across your solution below

Execute this:
regsvr32.exe ole32.dll 

well done! Thank you very much!

---

Blade003

Answer 8

Here is the script to solve is issue:

USE

 

master;

GO

EXEC

 

sp_configure 'show advanced option', '1';

RECONFIGURE

 

;

EXEC

 

sp_configure;

EXEC

 

sp_configure 'network packet size', 14336;

RECONFIGURE

 

WITH OVERRIDE;

Answer 9

sqldoc, thanks a lot. how do you come to this concluson!!!

Microsoft is a BLACK BOX.

Answer 10

Here is the script to solve is issue:

USE

 

 

master;

GO

EXEC

 

sp_configure 'show advanced option', '1';

RECONFIGURE

 

;

EXEC

 

sp_configure;

EXEC

 

sp_configure 'network packet size', 14336;

RECONFIGURE

 

WITH OVERRIDE;

What you should try is the following:
1. Re-register the MSXML DLLs (MSXML3/MSXML6) on your Server
2. Re-register the ole32 DLL because there is some amount of COM automation involved here
3. Re-register the MsDtsSrvrUtil.dll
4. Check if you are on build 3042 or above for the SQL Server Database Engine and the Management Studio Tools
5. Check if are able to modify the Maint Plans from another SSMS installed on another machine?

Changing the network packet size without consulting Microsoft CSS can affect a database engine drastically and you could land up with a number of memory related issues!!!

---

This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL