May 5, 2011 at 6:41 am
I encountered the problem to delete the DB Backup maintenance plan from my SQL Server 2000 instance after i try to add a job step in the job generated from Maintenance plan, when i use Enterprise manager and right click the MP to delete, the EM keep not responding...
However,i can create new MP with no issue.
Just would like to get rid of MP which are not in use...any workaround?
appreciate your response...thanks...
can i delete manually??
any sys tables from msdb which i can look into?
May 5, 2011 at 7:14 am
The following thread may be helpful to you:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 5, 2011 at 7:34 am
Thanks for the help.
FYI, i m using SQL Server 2000 instead..
the manual delete query stated above is referring to SQL Server 2005 ?
there is no change on the hostname as well...
any other workaround is much appreciated...
May 5, 2011 at 7:40 am
Any open tran on those tables that are not getting commited. God knows I locked myself out so many times I can't count that high.
May 5, 2011 at 7:50 am
Can you delete the job?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 5, 2011 at 7:54 am
yes, i have deleted the job..
after that i did create new maintenance plan for DB full backup and log backup,the two new jobs (generated from MP) are working fine without problem...
so, now i would like to delete the older MP but no luck...
May 5, 2011 at 8:02 am
golden-1131024 (5/5/2011)
yes, i have deleted the job..after that i did create new maintenance plan for DB full backup and log backup,the two new jobs (generated from MP) are working fine without problem...
so, now i would like to delete the older MP but no luck...
Open trasactions???????????????
DBCC OPENTRAN
May 5, 2011 at 8:07 am
no..
there is no open transaction..
May 5, 2011 at 8:10 am
I guess you tried killing EM and rebooting the machine?
I've had a similar issue in 2k5 where I couldn't delete the MP because the credentials of the login used in the connection where changed.
So maybe there's something similar going on there. But I would expect a timeout after sometime AND an error message.
Plan Z might be to reinstall the tools.
Is the machine up to date in the service packs?
May 5, 2011 at 8:12 am
Removed Post.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 5, 2011 at 8:13 am
Welsh Corgi (5/5/2011)
After you identify the process then you want to kill the SPID.
Sorry, we're all telapatically telling you to run sp_who2 to find if you're connection is blocked... and then kill it if appropriate.
May 5, 2011 at 8:15 am
Welsh Corgi (5/5/2011)
Removed Post.
Too late :hehe:.
May 5, 2011 at 8:16 am
You got me, LOL. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 5, 2011 at 8:18 am
there should not be a blocking happen as i should be notified through my blocking alert notification..
my concern is...
will this MP affect any of my current DB engine operation?
if it is not..i think i will just leave it there until my upcoming migration...
May 5, 2011 at 8:22 am
golden-1131024 (5/5/2011)
there should not be a blocking happen as i should be notified through my blocking alert notification..my concern is...
will this MP affect any of my current DB engine operation?
if it is not..i think i will just leave it there until my upcoming migration...
Should not?
sp_who2 F5
2 seconds to type and run. Then you KNOW.
We can't tell you what the plan does so we have no idea of the impacts it can have. The obvious reality here is that you "never" had problems with it so far so I don't really see that changing, especially since you can't access the plan.
I'm personnally sutborn so I'd keep looking but maybe you're smarter than me !
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply