Error 14261 The Specified Primary Server_name

Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Log shipping error? 14261 Log shipping error? 14261 Rate Topic Display Mode Topic Options Author Message Melissa KadiriMelissa Kadiri Posted Monday, April 12, 2004 10:22 AM SSC-Enthusiastic Group: General Forum Members Last Login: Saturday, November 15, 2008 1:08 PM Points: 177, Visits: 23 Trying to setup logshipping for one instance/database, and I keepgetting this error: "Error 14261: The specified primary_server_name.primary_db ('C') already exists". The error occurs immediately after the primary database is fully dumped forlog shipping initialization of the target. I am not even prompted for a login and password for the target instance. The database is not named "C".With SQL Enterprise, I have successfully setup logshipping for several databases (different instances) using the Database Maintenance Plan Wizard -- so the point-and-click method is very straightforward, and has been foolproof with this exception. The target instance/database name is definitely NOT the same as the primary instance/database name. I've tried this three times already, with the same error.Anyone have any ideas? Regards, Melissa Post #110758 Nicholas CainNicholas Cain Posted Monday, April 12, 2004 10:29 AM SSCrazy Group: General Forum Members Last Login: Wednesday, October 5, 2016 1:21 PM Points: 2,038, Visits: 6,198 It's a bug, you have to clean up the log shipping tables in msdb. Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;298743&sd=tech Shamless self promotion - read my blog http://sirsql.net Post #110760 Melissa KadiriMelissa Kadiri Posted Monday, April 12, 2004 10:47 AM SSC-Enthusiastic Group: General Forum Members Last Login: Saturday, November 15, 2008 1:08 PM Points: 177, Visits: 23 Woohoo! That was it! Thank

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 SQL Server 2000 Forums Import/Export (DTS) and Replication (2000) Log Shipping - copying initialization file Reply to Topic Printer Friendly Author Topic chris_wood99 Yak Posting Veteran 70 Posts http://www.sqlservercentral.com/Forums/Topic110758-5-1.aspx Posted-07/29/2005: 12:04:14 After I have been through the configuration of log shipping and the process starts I am receiving the error 'unable to copy initialization file to the secondary server ''. I have configured the log shipping to set up a new database on the secondary server.Then if i try something different and run it again i get :'error 14261 - the specified primary_server_name.primary_database_name ('M') http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53014 already exists' Does anyone know the table to delete this record? tkizer Almighty SQL Goddess USA 38200 Posts Posted-07/29/2005: 14:58:01 Yes. Delete the rows in the msdb.dbo.log_shipping* tables on both servers. If you still run into the unable to copy initialization file problem, then you can setup the database on the secondary server manually by using RESTORE DATABASE with an undo file. Then in the log shipping setup, you tell it that the database already exists.Tara Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) S

Primary server running Win Server 2003 withe Service pack 2 and SQL Server 2005 with service pack 2 and one http://www.bigresource.com/MS_SQL-SQL-Server-2005-Log-Shipping-Error-14262-bfe0hNXV.html secondary server runnung Win Server 2003 R2 with service pack 2 and http://www.oracle.com/pls/db10g/db10g.error_search?search=s SQL Server 2005 with service pack 2. All permission setting look ok . Can anyone help View 4 Replies Similar Messages: Log Shipping Error - Failing To Save Secondary Server Configurations Err # 14262 Log Shipping Monitor Our Of Sync SQL Server 2005 SQL Server 2005 - Log Shipping error 14261 - Missing Sp_change_primary_role And Sp_change_secondary_role SQL Server 2005 Log Shipping And 3rd Party Tape Backups SQL Server 2005 Log Shipping And Subsequent FULL Backups That Are Needed Recovery :: Error While Executing Script On Log Shipping Secondary Server? Log Shipping From SQL Server 2000 To SQL Server 2005 Log Shipping Between Sql Server 2000 64 Bits And Sql Server 2005 error 14261 the 32 Bits SQL 2005 Log Shipping SQL 2005 Log Shipping Log Shipping Error Log Shipping ERROR HELP Log Shipping Error SQL 2005 Log Shipping Setup Log Shipping Support 2005 SP1 Truncating T-Log's In SQL 2005 Log Shipping MS SQL 2005 Log Shipping And Altering A DB Log Shipping Between SQL 2005 And SQL 2000 Log Shipping Error On SQL 2000 SP4 Log Shipping Error 4323 Log Shipping Monitor Report Error SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. ) SQL 2005 Log-shipping/replication Linked Servers Slow Transaction Log-Shipping Restores (SS 2005) Log Shipping(sqlserver 2005) Backup Job Failure Error Messages From Log Shipping Job That No Longer Exists Log Shipping Error: 60000, Severity: 10, State: 1 Log Shipping - Switching Recovery Model In Log Shipping DB Design :: Log Shipping Alert Job Showing Error 14220 Unable To Connect To SQL Server 2005 (error: 26 - Error Locating Server/Instance Specified) Log Shipping: How To Failback After A Failover Log Shipping? SQL 2012 :: Transaction Log Shipping Secondary Error - Tuf Is Not A Valid Undo File For Datab

and other troubleshooting information in these books. Error Search Results Your search matched 15567 topics. Oracle Database 10g Error Messages AMD-00100: not found: string "string" AMD-00101: cannot create string "string"; metadata entity already exists AMD-00102: invalid metadata entity: string "string" AMD-00103: %s "string" does not have a string AMD-00104: Level "string" cannot be added to the hierarchy; parent and child parameters represent the same level AMD-00105: Level "string" cannot be added to the hierarchy; the specified parent level "string" is already the parent of "string" AMD-00106: parent string "string" must be removed before child string "string" can be removed AMD-00107: no root level in hierarchy: "string" AMD-00108: Dimension "string" is improperly mapped; the dimension has string hierarchies mapped, but hierarchy level "string" has string columns mapped AMD-00109: Parent metadata entity has too many child entities. string "string" has more than string string AMD-00110: parameter string of "string" not valid AMD-00111: PROCEDURE string, invalid directory: "string" AMD-00112: PROCEDURE string, invalid mode AMD-00113: PROCEDURE string, invalid operation AMD-00114: PROCEDURE string, internal error AMD-00115: PROCEDURE string, invalid file handle AMD-00116: PROCEDURE string, read error AMD-00117: input file "string" not found AMD-00118: output file "string" already exists AMD-00119: analytic workspace dimensions not specified in input AMD-00120: dimension #string: analytic workspace dimension name not specified AMD-00121: dimension #string: analytic workspace hierarchy not specified AMD-00122: dimension #string: analytic workspace hierarchy dimension not specified AMD-00123: dimension #string: analytic workspace hierarchy dimension value not specified AMD-00124: dimension #string: analytic workspace GID variable not specified AMD-00125: dimension #string: analytic workspace column level dimension not specified AMD-00126: dimension #string: analytic workspace column level relation not specified AMD-00127: dimension #string: RDBMS dimension column not specified AMD-00128: dimension #string: RDBMS parent column not specified AMD-00129: dimension #string: RDBMS GID column not specified AMD-00130: dimension #string: RDBMS dimension column data type not specified AMD-00131: dimension #string: RDBMS parent column data type not specified AMD-00132: dimension #string: RDBMS GID column data type not specified AMD-00133: measure #strin