FIX: "Cannot insert duplicate Key with unique index" error occurs when you run BizTalk Server backup job

Applies to: BizTalk Server 2013 BranchBizTalk Server 2013 DeveloperBizTalk Server 2013 Enterprise


Consider the following scenario:
  • You configure log shipping in Microsoft BizTalk Server.
  • You have one or more instances of SQL Server, and there's a SQL Server Agent job that hits multiple databases across job steps.
  • You run the BizTalk Server backup job.
In this scenario, the log shipping configuration fails, and you receive the following error message:
Msg 2601, Level 14, State 1, Procedure bts_ImportSQLAgentJobs, Line 59
Cannot insert duplicate key row in object '<object name> ' with unique index '<index name>'


Cumulative update information

This issue was first fixed in the following cumulative update of BizTalk Server:


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


For information about the service packs and cumulative update list for BizTalk Server, see KB 2555976: Service pack and cumulative update list for BizTalk Server .

For more information about BizTalk Server hotfixes, see KB 2003907: Information about BizTalk hotfixes and cumulative update support .