February 16, 2006 at 3:16 pm
Greetings, I am attempting to set up log shipping. I went through the steps to create the maintenance plan and it failed the first time due to an error. I corrected the error and upon rerunningthe plan it faile with Error 14261 The specified primary_server_name.primary_database_name already exists. I found a bug note/workaround at Mircrosoft support and the workaround is to run the following stored procedures;
sp_delete_log_shipping_primary
sp_delete_log_shipping_plan
sp_delete_log_shipping_seconday
sp_remove_log_shipping_monitor.
I have run these procedures on the primary server but the sp_delete_log_shipping_plan and the sp_remove_log_shipping_monitor don't appear to exist on the standby server. I did run the other two on the standby server. After running the procedures I still encounter the 14261 error. I am at a loss and would appreciate any suggestions. Thanks.
February 16, 2006 at 7:13 pm
The problem is resolved. I had upgraded the standby server from standard to enterprise edition and it turns out when that is done some log_ship* tables are not created. See microsoft KB295306. Thanks.
February 17, 2006 at 3:59 am
http://support.microsoft.com/kb/314515/EN-US/
Frequently asked questions - SQL Server 2000 - Log shipping
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply