Restoring BizTalk Server 2004

Instructions for restoring BizTalk Server 2004. See Backing Up BizTalk Server 2004 for backup instructions.


Determine if you’re doing full log restores or restoring to Stop Marks.

Stop the following services:

  • BizTalk Service: BizTalk Group
  • BizTalk SharePoint Messaging Manager
  • Enterprise Single Sign-On Service
  • Rules Update Service

Copy the backup files from the backup folder to your operational folder.

Create a SQL script with these commands (edit database names and paths, as appropriate):

— BizTalk Database Restoration Script
— DatabaseName = the BizTalk Database to restore.
— DB/LogFileName = the BizTalk backup data and log file names.
— StopMark = the BizTalk Stop Mark at which the backup occurred (looks like “BTS_2005_04_01_16_22_29_109“)

RESTORE Database DatabaseName FROM DISK = ‘x:\BizTalkBackupFolder\DBFileName’

RESTORE LOG DatabaseName FROM DISK = ‘x:\BizTalkBackupFolder\LogFileName’

RESTORE LOG FROM DISK = ‘x:\BizTalkBackupFolder\LogFileName’

Run the MS SQL Query Analyzer:

  • Connect to the SQL server storing the BizTalk databases (you may need to provide authentication)
  • Open/Paste the script(s) you created above
  • Repeat/script these steps for each of the following databases (default names; modify for your environment):
    • BizTalkDTADb
    • BizTalkMgmtDb
    • BizTalkMsgBoxDb
    • BizTalkRuleEngineDb
    • SSODB
    • TPM

Note errors and take corrective action. Restart services when complete.

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.

One Response to Restoring BizTalk Server 2004

  1. Pingback: Backing up BizTalk Server 2004 « OpsanBlog

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 )

Facebook photo

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

Connecting to %s

%d bloggers like this: