SQL Server Performance Forum – Threads Archive
Logshipping Error in SQL 2000 Ent. Edi.!! Hple plzHi 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 Thanks!!
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!! Thanks!!
Check this KBAhttp://support.microsoft.com/kb/298743/ to resolve the issue. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.