Wikis - Page Details

First published by Lex Hegt (fMicrosoft Partne)
When: 22 Feb 2012 12:24 PM
Last revision by Maheshkumar S Tiwari
When: 10 Sep 2013 12:28 PM
Revisions: 37
Comments: 26

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

Aspects of Backup for BizTalk Databases

Introduction
Why and how to make Log Shipping Backups
How to add/remove custom databases to the backup
Clean up backup artifacts
See Also

Introduction

When it comes to making backups of BizTalk, there is only one way that is supported by Microsoft; you need to make Log Shipping Backups. A number of usable articles have been written about making backups of BizTalk databases and other related databases. These articles are summed up and categorized in this article.

Why and how to make Log Shipping Backups

For BizTalk Microsoft supports only Log Shipping backups. Why?
Make Marked backups instead of regular Full Backups. This article provides many insides of how the Backup BizTalk Server job works
The original article on MSDN on making Marked backups
Configuring/using Log Shipping Backups can be found here

How to add/remove custom databases to the backup

In extension of making backups of your BizTalk databases, this article explains how custom databases should be added to the Backup BizTalk Server job.
The article also gives some more inside information about the view which shows the databases which are in your BizTalk backup
How to remove custom database from BizTalk Log Shipping can be found here

Note: Only the addition of SQL Server databases is supported.

Clean up backup artifacts

Automatically remove old backup files with a SQL Server Maintenance Plan is described here
Automatically remove old backup files with a SQL Script is described here
Delete old backup files and folders with PowerShell is described here
Query to retrieve the number of records in the MarkLog tables in the TechNet Galleryis here
Cleaning up large MarkLog tables can be found here