Backup BizTalk Server Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Backup BizTalk Server Databases

Backup BizTalk Server Databases

Rate Topic

Display Mode

Topic Options

Author

Message

Eldose

Posted Monday, August 10, 2009 4:43 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 3:40 AM
Points: 15, Visits: 200

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...

Post #767738

Scott Ohar

Posted Tuesday, August 11, 2009 7:21 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:30 AM
Points: 712, Visits: 639

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)

Bleeding Edge - just means alot of sleepless nights

Post #768569

Eldose

Posted Thursday, August 13, 2009 7:05 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 3:40 AM
Points: 15, Visits: 200

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.

Post #770115

Scott Ohar

Posted Thursday, August 13, 2009 7:12 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:30 AM
Points: 712, Visits: 639

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.

Bleeding Edge - just means alot of sleepless nights

Post #770121

« Prev Topic | Next Topic »

Permissions