|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Tuesday, May 26, 2009 10:44 PM
Points: 152,
Visits: 348
|
|
Hi,
I had a few maintenance plan defined in SQL2005 server. Then I renamed my Server ( windows and SQLserver). Now, when I want to drop those maintenance plan I'm getting error.
I have even modified the owner of the related jobs but no success yet
Could you tell me how I can remove those maintenance plans in such situation?
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: Friday, December 09, 2011 6:44 PM
Points: 715,
Visits: 980
|
|
This thread says you can't
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=297149
But found this
1. Select the ID with the select statement
select * from sysmaintplan_plans
2. Replace with the selected ID and run the delete statements
delete from sysmaintplan_log where plan_id = ''
delete from sysmaintplan_subplans where plan_id = ''
delete from sysmaintplan_plans where id = ''
3. Delete the SQL Server Jobs with the Management Studio
Please check it out first before deleting anything
here the thread to it
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, September 21, 2011 1:19 PM
Points: 933,
Visits: 1,016
|
|
Hi,
It might be similar to an issue I encountered with SQL 2000 ..
http://sqllearnings.blogspot.com/2009/01/error-14274-cannot-add-update-or-delete.html
Mohit.
---
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog.
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. 
How to ask for help .. Read Best Practices here.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 26, 2009 10:44 PM
Points: 152,
Visits: 348
|
|
1. Select the ID with the select statement
select * from sysmaintplan_plans
2. Replace with the selected ID and run the delete statements
delete from sysmaintplan_log where plan_id = ''
delete from sysmaintplan_subplans where plan_id = ''
delete from sysmaintplan_plans where id = ''
3. Delete the SQL Server Jobs with the Management Studio
That gave me the answer Thank you :)
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 26, 2009 10:44 PM
Points: 152,
Visits: 348
|
|
Mohit (3/7/2009)
Hi,
It might be similar to an issue I encountered with SQL 2000 ..
http://sqllearnings.blogspot.com/2009/01/error-14274-cannot-add-update-or-delete.html
Mohit.
I had tried this before but didn't resolve my problem
Thanks anyway :)
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, September 21, 2011 1:19 PM
Points: 933,
Visits: 1,016
|
|
Heh I expected as much; I have yet to rename any SQL 2005 servers. I am sure I'll get around to it; I'll have to keep this little note in mind :) Thanks.
---
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog.
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.
How to ask for help .. Read Best Practices here.
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, September 21, 2011 1:19 PM
Points: 933,
Visits: 1,016
|
|
Question ...
Was error similar to this:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 53)
?
---
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog.
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.
How to ask for help .. Read Best Practices here.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 26, 2009 10:44 PM
Points: 152,
Visits: 348
|
|
Mohit (3/8/2009)
Question ...
Was error similar to this:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 53)
?
nope ;)
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, September 21, 2011 1:19 PM
Points: 933,
Visits: 1,016
|
|
Nuts :p. I guess I'll have to butcher a server LOL thanks for the post :). I made a note about this on me blog so I wouldn't forget it :). Thanks.
---
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog.
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.
How to ask for help .. Read Best Practices here.
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: Friday, December 09, 2011 6:44 PM
Points: 715,
Visits: 980
|
|
Glad it helped i remembered doing the same thing in SQL 2000 with the same thing so i knew there be something similar in 2005.
|
|
|
|
