none
BizTalkBackup job issue-Where the BizTalk databases installed on different sql servers RRS feed

  • Question

  • Hi All,

    I recently configure Biztalk2016 server where MSGBOXDB on one SQL server and other DTA,SSO,MGMT DBS on other SQL server with three different instance.

    When I configured BizBackup job im getting error like  below at step 3

    Executed as user: Domain\user. The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "sqlinstance" was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391)  OLE DB provider "SQLNCLI11" for linked server "sqlinstance" returned message "No transaction is active.". [SQLSTATE 01000] (Error 7412).  The step failed.

    Before the error is different it says no sys.server  if required use add linked server. when I add that it failed with above error


    Thanks.

    Friday, December 6, 2019 6:29 AM

All replies

  • Getting new error now

    Executed as user: domain\user. BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)  Cannot open backup device 'backup path' SQLserver2_SQLINSTANCE_BTDTA_BizTalkDTADb_Full_BTS_2019_12_06_10_58_10_977.bak'. Operating system error 3(The system cannot find the path specified.). [SQLSTATE 42000] (Error 3201)  Processed 904 pages for database 'BAMPrimaryImport', file 'BAMPrimaryImport' on file 1. [SQLSTATE 01000] (Error 4035)  Processed 2 pages for database 'BAMPrimaryImport', file 'BAMPrimaryImport_log' on file 1. [SQLSTATE 01000] (Error 4035)  BACKUP DATABASE successfully processed 906 pages in 0.199 seconds (35.531 MB/sec). [SQLSTATE 01000] (Error 3014)  Processed 3088 pages for database 'BizTalkMsgBoxDb', file 'BizTalkMsgBoxDb' on file 1. [SQLSTATE 01000] (Error 4035)  Processed 2 pages for database 'BizTalkMsgBoxDb', file 'BizTalkMsgBoxDb_log' on file 1. [SQLSTATE 01000] (Error 4035)  BACKUP DATABASE successfully processed 3090 pages in 0.248 seconds (97.319 MB/sec). [SQLSTATE 01000] (Error 3014)  Processed 680 pages for database 'BizTalkRuleEngineDb', file 'BizTalkRuleEngineDb' on file 1. [SQLSTATE 01000] (Error 4035)  Processed 2 pages for database 'BizTalkRuleEngineDb', file 'BizTalkRuleEngineDb_log' on file 1. [SQLSTATE 01000] (Error 4035)  BACKUP DATABASE successfully processed 682 pages in 0.034 seconds (156.494 MB/sec). [SQLSTATE 01000] (Error 3014).  The step failed.

    For DTA,MGMT,SSO instance

    BackupDiskFile::CreateMedia: Backup device 'D:\Path\Sservername_SQLINSTANCE_BTDTA_BizTalkDTADb_Full_BTS_2019_12_06_10_58_10_977.bak' failed to create. Operating system error 3(The system cannot find the path specified.). error


    • Edited by Phani_B Friday, December 6, 2019 12:57 PM
    Friday, December 6, 2019 11:03 AM
  • hello All 

    Please help me

    Thursday, December 12, 2019 8:21 AM
  • You have to make sure that the service account that is running the job has write access on the destination folder and pay attention to the specified destination path relative to the particular server running the job. 

    I'll tell you also that the limited amount of information you have provided makes it very difficult for anyone to assist. A simple diagram of the configuration would help along with the user context information for each job. For instance, are these hosts on a domain? Normally all your backups would go to the same loaction but if you have these DBs on differnet hosts/servers then you would need to use a UNC path, not the local drive. 



    • Edited by Malisk Monday, December 16, 2019 9:59 PM
    Monday, December 16, 2019 9:56 PM