October 15, 2008 at 6:49 pm
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
October 15, 2008 at 9:07 pm
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
October 20, 2008 at 5:04 pm
Many thanks, David, much appreciated.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply