August 10, 2009 at 4:43 am
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...
August 11, 2009 at 7:21 am
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)
August 13, 2009 at 7:05 am
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.
August 13, 2009 at 7:12 am
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