While configuring logshipping in SQL server 2000 we are facing below error message
Error 14426: A log shipping monitor is already defined. Call sp_define_log_shipping_monitor with @delete_existing=1...
we tried excuting below mentioned SPs but it also doesnt work
EXEC sp_delete_log_shipping_primary @primary_server_name = N'source', @primary_database_name = N'pubs'
EXEC msdb.dbo.sp_delete_log_shipping_plan @plan_name = N'Pubs database backup', @del_plan_db = 1
Syntax
sp_delete_log_shipping_secondary
[ @secondary_server_name = ] 'secondary_server_name' ,
[ @secondary_database_name = ] 'secondary_database_name'