January 24, 2013 at 11:08 pm
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'
January 25, 2013 at 2:02 am
siddiquiakmal (1/24/2013)
Call sp_define_log_shipping_monitor with @delete_existing=1...
Have you tried removing the LS monitor as detailed above?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 6:03 am
Hi,
I tried executing the Monitor SP but it is failing and the entry of monitor server doesn’t exists in Log shipping monitor table.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply