Server Agent Job Failing

• John Reynolds-488748

  SSC Rookie

  Points: 38

  More actions

  October 15, 2008 at 6:49 pm

  #154813

  G'day,

  I've got an agent job that is basically taking the backups from another server and restoring them locally to create a training database. The stored procedure performing the work used a linked server definition to gain access to the backup files, which I think I've set up correctly, but I'm getting the following error when I run the job:

  Executed as user: . The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. [SQLSTATE 01000] (Error 7300). The step failed.

  Has anyone got any ideas?

  Many thanks in advanve,

  John R

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  October 15, 2008 at 9:07 pm

  #885610

  Try the following links;

  http://support.microsoft.com/kb/329332

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2676050&SiteID=1

  http://support.microsoft.com/kb/816701

  Hopefully this will help.

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

• John Reynolds-488748

  SSC Rookie

  Points: 38

  More actions

  October 20, 2008 at 5:04 pm

  #887362

  Many thanks, David, much appreciated.

  John