March 10, 2007 at 6:46 am
Hello please help,
I have a SQL Server 2005 Maintenance Plan question, and wondering if
anyone could assist? Here are the technical details:
SQL Server 2005 SP2 installed Problem: Deletion of Maintenance Plans (MP)
Description: I want to delete a MP, but I keep getting the following
error message:
The connection "Local server connection" is not found.
"This error is thrown by Connections collection when the specific connection element
is not found.(Maintenance_plan_name)"
The paket was created before installing SP2.
Does anyone have any suggestions, please?
Many thanks.
Dietmar
March 12, 2007 at 8:55 am
One enhancement that is done by SP2 is allowing to create maintenance plans without using Integration Services. Maybe the change messed something up. I did not test it yet.
A couple of suggestions:
- Try to create a new package and try to delete it, will it work?
- Leave the plan. Disable or delete the job that runs the plan.
- Try to edit this paln and re-define the local server connection. I am not sure about this advice, because I am not sure what connection we are talking about: the connection of your Management Studio to your server's MSDB database to get the plan or the connection inside the plan to the databases to be maintained.
- Are you running your Management Studio on the server or remotely? Try to run it locally on the server.
Regards,Yelena Varsha
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply