Backup BizTalk Server Databases

  • In my environment there is two biztalk servers connected to one sql server. For each biztalk server there is different biztalk databases like

    BizTalkDTADb & BizTalkDTADb1

    BizTalkMgmtDb & BizTalkMgmtDb1

    BizTalkMsgBoxDb & BizTalkMsgBoxDb1

    SSODB & SSODB1

    and BizTalkEDIDb & BizTalkRuleEngineDb are common for both the biztalk servers.

    In my sql server two jobs are available in the sql server agent job for biztalk database backup

    1. Backup BizTalk Server (BizTalkMgmtDb)

    2. Backup BizTalk Server (BizTalkMgmtDb1)

    so to take the backup of both the biztalk server jobs I enabled this two jobs.

    As BizTalkEDIDb & BizTalkRuleEngineDb are common to both biztalk servers it is backing up in both the jobs. I don't want this databases to be backed up in both the jobs. How can we achieve this? Or is it ok to backup these databases in both the jobs?

    Please help...

  • You want to enable the default Biztalk Agent Jobs.

    It will loop through and handle all Databases related to biztalk, you will need to go into each step of the agent and put the backup path/days to store ect...

    DTA Purge and Archive (BizTalkDTADb)

    Backup BizTalk Server (BizTalkMgmtDb)

  • In My srever two Biztalk Backup Jobs are available.

    1. Backup BizTalk Server (BizTalkMgmtDb)

    Backing up the following databases

    BizTalkDTADb , BizTalkMgmtDb , BizTalkMsgBoxDb , SSODB , BizTalkEDIDb & BizTalkRuleEngineDb

    2. Backup BizTalk Server (BizTalkMgmtDb1)

    Backing up the following databases

    BizTalkDTADb1 , BizTalkMgmtDb1 , BizTalkMsgBoxDb1 , SSODB1 , BizTalkEDIDb & BizTalkRuleEngineDb

    You can see BizTalkEDIDb & BizTalkRuleEngineDb are backing up by both the jobs. I don't want this databases to be backed up by both the jobs. Please suggest how I can proceed on this.

  • You would have to change the store proc's related to those jobs, which isnt recommended. If you do that I would suggest a testing server... or you could use SQL Server native backup for each database but then you run into the problem with not being able to use the purge and archive function those jobs give.

    My suggestion would be to post on the biztalk forums on microsoft on how to proceed with this task.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply