Backing up BizTalk Server 2004

Step-by-step reference to backing up BizTalk Server 2004. See Restoring BizTalk Server 2004 for restoration instructions.

Include the SSO Database as part of your backup (recommended):

  • Open SQL Enterprise Manager.
  • Open BizTalkMgmtDB (default name for the BT Management Database) and expand Tables.
  • Right click adm_otherbackupdatabases, click “Open Table” and “Return all rows“.
  • In the Data in Table diaog box add a row with the follwing values:
    • DefaultDatabaseName: SSODB
    • Database Name: SSODB
    • ServerName: (server name)
    • BTSServerName: (server name)
  • Close the Data in Table dialog box.

Alter the SQL Backup job:

  • Open SQL Enterprise Manager
  • Choose server
  • Expand Management, SQL Server Agent and click Jobs
  • Open the Backup BizTalk Server job
  • In the Backup BizTalk Server properties, click the “Steps” tab
  • Click “Backup Full” and click Edit
  • In the “Edit Job Step” dialog box, modify the “<destination path>” string to the path you’d like to save the backup files
  • Make the same path change for the “MarkAndBackupLog” step
  • Click OK to close the Backup properties dialog box and return to SQL Enterprise Manager.

Ensure SQL Server Agent is running with credentials permitting it to write to the folder specified in “destination path”, above.

Testing the backup job:

  • Open SQL Enterprise Manager.
  • Choose server
  • Expand Management, SQL Server Agent and click Jobs
  • Right-click the Backup BizTalk Server job and click “Start Job”
  • In the “Start Job” dialog box, click “Start”
  • Right-click the Backup BizTalk Server job and click “View Job History”

The job should have run successfully, otherwise interpret any error messages (typically invalid path or permissons), resolve and test again.

This process backs up both the data and log files. Running the job a second time should create only a log file as the period for the next database backup should not have been reached (by default, it is set to 15 minutes).

Once you’ve set these jobs up, you will need to manage the files, archiving to another share or deleting on a regular basis.

About Michael Coates
I am a pragmatic evangelist. The products, services and solutions I write about fulfill real-world expectations and use cases. I stay up-to-date on real products I use and review, and share my thoughts here. I apply the same lens when designing an architecture, product or when writing papers. I am always looking for ways that technology can create or enhance a business opportunity .. not just technology for technology's sake. My CV says: Seasoned technology executive, leveraging years of experience with enterprise and integration architectural patterns, executed with healthy doses of business acumen and pragmatism. That's me. My web site says: Technology innovations provide a myriad of opportunities for businesses. That said, having the "latest and greatest" for its own sake isn't always a recipe for success. Business successes gained through exploiting innovation relies on analysis of how the new features will enhance your business followed by effective implementation. Goals vary far and wide: streamlining operations, improving customer experience, extending brand, and many more. In all cases, you must identify and collect the metrics you can apply to measure your success. Analysis must be holistic and balanced: business and operational needs must be considered when capitalizing on a new technology asset or opportunity.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: