Error 14261 Sql
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL 2012 Log Shipping error 14261 SQL Server > SQL Server High Availability and Disaster Recovery Question 0 Sign in to vote I have two servers and I had log shipping working but could not add any additional databases to the process. I deleted all the log shipping and I am still unable to add the databases back to the log shipping configuration. The process fails while trying to all the Secondary Log shipping configuration. I get the following error: The specified @name ('Log shipping Primary Server Alert.') already exists. (.Net SqlClient Data Provider) and it specifically refers to my secondary server by name in the error also referencing the stored procedure sp_verify_alert. I have not been able to find a solution. Please help. Thursday, March 19, 2015 4:39 PM Reply | Quote Answers 0 Sign in to vote I sincerely appreciate your help. I found the problem. There were two alerttasks (under the Alerts folder) which were residual to the process. I just deleted those Alert tasks and the error is gone and I can now recreate all my Log Shipping jobs. Proposed as answer by Michelle LiModerator Friday, March 20, 2015 6:45 AM Marked as answer by RKCLLC Friday, March 20, 2015 12:26 PM Thursday, March 19, 2015 7:24 PM Reply | Quote All replies 0 Sign in to vote Looks like you have to manually clean all log shipping information and also make sure drop all log shipping jobs http://www.databaseskill.com/3011872/ Edited by dave_gona Thursday, March 19, 2015 5:03 PM Thursday, March 19, 2015 4:57 PM Reply
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error 14261 - Trying to create log shipping Want to Advertise Here? Solved Error 14261 - Trying to create log shipping Posted on 2008-10-28 MS SQL Server 1 Verified Solution 2 Comments 824 Views Last Modified: 2012-05-05 I am trying to create a new log shipping plan. I have deleted all log shipping plans https://social.msdn.microsoft.com/Forums/sqlserver/en-US/66186117-c07e-4c10-867d-b61f5b107961/sql-2012-log-shipping-error-14261?forum=sqldisasterrecovery from both servers, primary and secondary. However when I finish creating the plan, and click finish, I get the error message 'The Specified plan_name ('MTUKDB4.proddta_logshipping') already exists. However there are no plans. Can you please help? The primary server is MTUKDB4 The seconday server is MTUKDB7 The Database name is proddta 0 Question by:tajinderpal Facebook Twitter LinkedIn Google LVL 38 Best Solution byJim P. Probably something errant is stuck in the MSDB database. And I'm https://www.experts-exchange.com/questions/23854105/Error-14261-Trying-to-create-log-shipping.html 2k% so this is partly from memory. Go the MSDB database and see if you have any tables like log_shipping_% and or publishers and/or Go to Solution 2 Comments LVL 38 Overall: Level 38 MS SQL Server 19 Message Accepted Solution by:Jim P.2008-10-29 Probably something errant is stuck in the MSDB database. And I'm 2k% so this is partly from memory. Go the MSDB database and see if you have any tables like log_shipping_% and or publishers and/or subscribers. See if something is stuck in there. 0 LVL 1 Overall: Level 1 Message Expert Comment by:SactoCal2008-10-30 I had a very similar problem also and ran across this post. Using the tip left by jimpen, I went into the msdb...log_shipping_* tables on the secondary server and remove all references the said database/logshipping plan I was working on. THAT problem solved =) Thanks P.S. I could not delete the old references, so I simply changed the name of the database it was referencing. 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Featured Post How to run any project with ease Promoted by Quip, Inc Manage projects of all sizes how you want. Grea
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask https://www.experts-exchange.com/questions/24192031/SQL-Server-2000-Enterprise-Edition-Error-14261-The-specified-primary-server-name-primary-database-name-already-exists.html a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > SQL Server 2000 error 14261 Enterprise Edition: Error 14261: The specified primary_server_name.primary_database_name already exists. Want to Advertise Here? Solved SQL Server 2000 Enterprise Edition: Error 14261: The specified primary_server_name.primary_database_name already exists. Posted on 2009-03-02 MS Applications MS Server Apps Windows 2000 MS SQL Server 1 Verified Solution 10 Comments 754 Views Last Modified: 2012-05-06 SQL Server error 14261 sql 2000 Enterprise Edition: Error 14261: The specified primary_server_name.primary_database_name already exists. I tried to clean up all log_shipping_* tables but the error still shows up. 0 Question by:ryanwei88 Facebook Twitter LinkedIn Google Best Solution byryanwei88 I am following the steps as "http://msdn.microsoft.com/en-us/library/aa496029.aspx" to set logshipping in SQL 2000 environment. I upgraded the db from standard edition into enterprise edition and following Go to Solution 7 Comments LVL 23 Overall: Level 23 MS Applications 11 MS Server Apps 3 MS SQL Server 1 Message Expert Comment by:redrumkev2009-03-02 ryanwei88, How are you doing? See if this helps: http://support.microsoft.com/default.aspx?scid=kb;en-us;q298743&sd=tech Kevin 0 Message Author Comment by:ryanwei882009-03-02 I tried this. but the issue remained. 0 LVL 23 Overall: Level 23 MS Applications 11 MS Server Apps 3 MS SQL Server 1 Message Expert Comment by:redrumkev2009-03-03 ryanwei88, Did you upgrade from standard edition to enterprise edition, because there is an issue with that