log shipping error in SQL 2000 Ent. Edi.!! Help

[parsql]

Hi why i am getting this error after i create the plan to do logshipping!!

after i create plan and when it try to run the full back up then initialization it givs me error saying that:

Error 14426: A log shipping monitor is alread defined. call sp_define_logshippping_monitor with @delete_existing = 1

i tried running on the destination server but it gives me error Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '@delete_existing'.

do i need to run this on source server? How can i check if log shipping monitor is runnig? or defined?

please help!!

thanks

 

[parsql]

i tried running sp_define_logshippping_monitor 'NAME',1(for NT),1
but still getting
Error 14426: A log shipping monitor is alread defined. call sp_define_logshippping_monitor with @delete_existing = 1
please advise!!

 

[Catadmin]

Have you verified that you don't already have a maintenance plan set up with log shipping?

It sounds like you need to do a removal regardless and start from scratch. Check out the following Microsoft KB article...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

Also, might want to check the FAQ section and get MRDenny's T-SQL version of Log Shipping. It works much better than the DBMP version of it.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"