July 21, 2008 at 6:32 am
Saving maintenance plan failed.
Howdy. Trying to use the wizard to create simple backup. No frills at all. I receive the following error.
Your thoughts?
thanks
===================================
One or more arguments are invalid
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()
at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
July 21, 2008 at 6:51 am
I've never had much luck with maint. plans in SQL 2005, especially before the service packs came out.
I'd make sure you have SP2 on your server, but other than that you're probably better off just writing a script to do your backups and setting that up as a job rather than messing with maint. plans.
The Redneck DBA
July 21, 2008 at 7:12 am
I'm sure you're right, but still, it should work. This is a new install with all the packs. Running great otherwise.
July 21, 2008 at 7:19 am
Oh, I agree that it should work. I was just saying it's been my experiance it's easier to spend 5 min. writing a quick script and plopping it into a job then spending a whole day getting the maint. plans to work.
If you do end up going the maint. plan route, just be careful with it. There were all sorts of issues with the backup stuff in there for the RTM version. They were supposedly fixed by SP1 (or SP2?) but I haven't played with them enough to know if they were ever 100% fixed.
On piece of advice...if you ever need to drop a database that is backed up in a maint. plan, make sure you take it out of the maint. plan before you drop it. I once dropped a db and didn't drop it from the maint. plan and caused myself all sorts of headaches. When I would try to take it out of the maint plan it wouldn't let me, failing with an error telling me the DB didn't exist.
They could have done a lot better job of implementing the maint. plan stuff than the did if you ask me.
The Redneck DBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply