Checklist: Back Up and Restore BizTalk Server Databases

Before attempting to back up or restore BizTalk Server, be sure to familiarize yourself with the processes involved.

Backing Up BizTalk Server

Step Reference
Learn how to back up and restore BizTalk Server. Best Practices for Backing Up and Restoring Databases

Backing Up and Restoring BizTalk Server Databases
Ensure that you have appropriate permissions to back up and restore BizTalk Server. Minimum Security User Rights
Configure the Backup BizTalk Server job. How to Configure the Backup BizTalk Server Job
Configure the server where backups will be stored. How to Configure the Destination System for Log Shipping
If you are using Business Activity Monitoring (BAM), back up the BAM databases. Backing Up and Restoring BAM
If you are using Enterprise Single Sign-on, back up the master secret. Managing the Master Secret

Restoring BizTalk Server

Step Reference
Restore your databases. How to Restore Your Databases
Update references to the BAM database names. How to Back Up the BAM Analysis and Tracking Analysis Server Databases

How to Update References to the BAM Analysis Server and Star Schema Database Names

How to Update References to the BAM Archive Database Name

How to Update References to the BAM Primary Import Database Name and Connection String

How to Update References to the BAM Notification Services Databases

How to Resolve Incomplete Activity Instances
If you are using Enterprise Single Sign-on, restore the master secret. Managing the Master Secret

See Also

Backing Up and Restoring the BizTalk Server Databases