Can't save maintenance plans - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Can't save maintenance plans

Author

Topic

bazil
Starting Member

6 Posts

Posted - 2008-06-17 : 09:55:27

Hi,

Whenever I create a maintenance plan either manualy or via the wizard, I get the following error message when saving it.

Does anyone know what might be wrong?

Best regards

===================================

Fehler beim Speichern des Wartungsplanes.
(Error when saving the maintenance plan.)

===================================

Mindestens ein Argument ist ungültig.
(At least one argument is invalid.)

------------------------------
Speicherort des Programms:
(Save location of programme:)

bei Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
bei Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()
bei Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-17 : 10:05:54

Translate in English. Does your SQL server has upto date SP and hot fixes?

bazil
Starting Member

6 Posts

Posted - 2008-06-18 : 08:21:07

Hi,

Just so that you know I'm a real beginner hence the nature of my question.

Could you help me to ascertain what the status is of SQL, ie. what versions and what plugins (hot fixes) are installed? I believe this is undertaken in teh SQL Manager by a 'Transact-SQL statement' but I can't find the tool to do this.

I found this however in the SQL Manager under a menu:

Best regards

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services-Clienttools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00(srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.3959
Microsoft .NET Framework 2.0.50727.42
Betriebssystem 5.2.3790

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-18 : 09:03:45

You need to apply SP2 for SQL server.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-18 : 22:24:30

Did you connect to sql as sysadmin?

bazil
Starting Member

6 Posts

Posted - 2008-06-19 : 06:16:55

Yes.

I connected as user 'sa'.

In the meantime I have downloaded SP2 and will be installing it.

Best regards

bazil
Starting Member

6 Posts

Posted - 2008-06-19 : 12:19:03

I have installed SP2 successfully but the problem persists:

===================================

Fehler beim Speichern des Wartungsplanes.
(Error when saving maintenance plan)

===================================

Mindestens ein Argument ist ungültig.
(At least one argument is invalid)

------------------------------
Speicherort des Programms:
(Save target of the programme):

bei
Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)

bei Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()

bei Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()

bazil
Starting Member

6 Posts

Posted - 2008-06-19 : 12:25:30

Solved!

Ending and restarting the Manager reolved the issue!

Thanks everyone

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources