Post reply

The specified primary_server_name.primary_database_name already exists

  • February 16, 2006 at 1:18 pm

    #152770

    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

    #621485

    I found the answer. Thanks.

  • March 7, 2006 at 11:05 pm

    #625321

    I am having the same problem. What was the answer?

  • March 8, 2006 at 9:04 am

    #625441

    Look in msdb database

  • March 8, 2006 at 9:23 am

    #625449

    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

    #625587

    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