SQL Server Performance

Logshipping Error in SQL 2000 Ent. Edi.!! Hple plz

Discussion in 'SQL Server Log Shipping' started by PatDeV, Aug 17, 2006.

  1. PatDeV New Member

    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

    Thanks!!
  2. PatDeV New Member

    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!!
  3. satya Moderator

    Check this KBAhttp://support.microsoft.com/kb/298743/ to resolve the issue.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page