logshipping error SQL 2K Ent. Editino

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

logshipping error SQL 2K Ent. Editino

Author

Topic

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-08-17 : 10:19:54

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

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-08-17 : 11:30:29

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!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources