February 16, 2006 at 1:18 pm
Greetings, I am setting up log shipping and it failed the first time and I am now receiveing Error 14261 The specified primary_server_name.primary_database_name already exists. I found the big note/workaround at Mircrosoft support and the workaround is to run the following stored procedures;
sp_delete_log_shipping_primary
sp_delete_log_shipping_pla
sp_delete_log_shipping_seconday
sp_remove_log_shipping_monitor.
I am unable to find any of these stored procedures. I am logged in as a user that is a member of the sysadmin role. I'm not sure what I am missing here and any help would be appreciated. Thanks.
February 16, 2006 at 2:35 pm
I found the answer. Thanks.
March 7, 2006 at 11:05 pm
I am having the same problem. What was the answer?
March 8, 2006 at 9:04 am
Look in msdb database
March 8, 2006 at 9:23 am
I had two difficulties, the first being the 14261 error. The workaround for this is to be found in KB article 298743 BUG: All Changes May Not Be Rolled Back when Log Shipping Maintenance Wizard fails. The second part of this is that the procedures do not exist on the standby server. In my case it was due to the fact that I had upgraded from standard to enterprise edition and there is a bug in the upgrade process such that these procedures are not created. This is addressed in KB article 295306. BUG: Log Shipping Elements are Missing After You Upgrade From Standard to Enterprised Edition. The resoloution is to run the instls.sql script shich is located in the \Install folder of the Enterprise Edition. I hope this helps.
March 8, 2006 at 10:08 pm
This helped KB article 298743 BUG: All Changes May Not Be Rolled Back when Log Shipping Maintenance Wizard fails
Thanks Greatly appreciated
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply