Error 14261 The Specified Name Already Exists

SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums Old Forums CLOSED - General SQL Server Error while setting up Log Shipping Forum Locked Printer Friendly Author Topic shahab03 Starting Member USA 28 Posts Posted-06/13/2006: 17:13:33 I am getting following error when setting up log shippingError 14261: The specified @name ('Log Shipping copy for NIMMAIN.vanxdb_logshipping') already exists. I have cleaned up all the log shipping related tables in msdb database on primary, secondary and monitoring sql server instances but I am still getting this error.Where else do I need to l look? or do? tkizer Almighty SQL Goddess USA 38200 Posts Posted-06/13/2006: 17:43:35 Was the maintenance plan deleted as well as the jobs?Each time the wizard fails, you must manually clear out the tables, so go back and make sure that all log_shipping* tables have been cleared out of all 3 instances.Tara Kizeraka tduggan shahab03 Starting Member USA 28 Posts Posted-06/14/2006: 09:23:50 Hello TaraThere were couple of jobs which were not deleted. Didnt have any problem after deleting them.By the way have you successfully performed a Log Shipping Role Change? Documentation is doesnt cover every aspect. ThanksShahab tkizer Almighty SQL Goddess USA 38200 Posts Posted-06/14/2006: 13:09:52 I have never successfully performed a log shipping role change. We tried it quite a few times in our tests. When we switch between our primary and disastery recovery site, switching is done manually. We then have to resetup log shipping going the other way. We switch 2-3 times per year to ensure that our disaster recovery plan works.Tara Kizeraka tduggan shahab03 Starting Member USA 28 Posts Posted-06/14/2006: 13:48:26 changing Logshipping roles seems easy from BOL...but I ve experienced lots of hurdles in each step....I am not able to execute:EXEC sp_change_secondary_role@db_name = 'test',@do_load = 1,@force_load = 1,@final_state = 1,@access_level = 1,@terminate = 1,@stopat = NULLGOwhen I executed this SP, I got an error:Server: Msg 22029, Level 16, State 1, Line 0sqlmaint.exe failed.Per followinghttp://support.microsoft.com/default.aspx?scid=kb;en-us;294397&Product=sql2kI can resolve the issue above by 1)Ensure that there are no outstanding transact

360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67729 Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/298743 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States)‎ Terms of use Privacy & cookies Trademarks © 2016 Microsoft

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 https://www.experts-exchange.com/questions/23854105/Error-14261-Trying-to-create-log-shipping.html Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website http://www.tek-tips.com/viewthread.cfm?qid=1514141 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 error 14261 log shipping plans 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 error 14261 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 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 Enabling OSINT in Activity Based Intelligence Promoted by Recorded Future A

Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft SQL Server: Setup and Administration Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft SQL Server: Setup and Administration Forum Log Shipping error thread962-1514141 Forum Search FAQs Links MVPs Log Shipping error Log Shipping error djj55 (Programmer) (OP) 18 Nov 08 08:57 Hello, With SQL 2000 I am getting an error Quote:Error 14261: The specified plan_name ('DB1.MyDB_logshipping') already exists. One thing that I do not understand is the name I entered was LogShipping_MyDB.This was after I executed CODEexecute msdb..sp_delete_log_shipping_primary @primary_server_name = N'DB1', @primary_database_name = N'MyDB'execute msdb..sp_delete_log_shipping_plan @plan_name = 'MyDb_logshipping'execute msdb..sp_delete_log_shipping_plan @plan_name = 'DB1.MyDb_logshipping'The first said complete the last two said does not exist.I have created other log shipping today and they seem to be working.Any ideas?djj RE: Log Shipping error JayKusch (MIS) 18 Nov 08 21:09 Have you looked in the actual log shipping tables in the MSDB database to see if the plan does indeed exist? ThanksJ. Kusch RE: Log Shipping error djj55 (Programmer) (OP) 19 Nov 08 07:45 Thank you for the reply.I did look into any table that started 'log' or had 'plan' in the name.Nothing out of line, and no MyDB.So after getting your reply, I looked on the destination server