Export (0) Print
Expand All

Marking Transactions, Full Backups, and Log Backups

Microsoft BizTalk Server enables you to run synchronized backups of all BizTalk databases. You synchronize your backups by using full database backups and transaction log backups in conjunction with a mechanism known as "marking transactions."

For each BizTalk database, the Backup BizTalk Server job creates a marking log backup every time it runs, and periodically creates a full backup.

Marking transactions

Marking transactions are transactions that place a mark into the transaction log of all databases participating in the transaction. The marking transaction blocks new distributed transactions from starting, waits for currently running distributed transactions to complete, and then executes to place the mark.

The mark represents a point that is transactionally consistent across all databases; you can use the mark with subsequent log backups to restore your databases to that point.

Full backups

When you run the Backup BizTalk Job, it runs the first step, BackupFull, once every period, not every time the job runs. You need to decide on the period: hourly (h/H), daily (d/D), weekly (w/W), monthly (m/M), or yearly (y/Y).

The first time Backup BizTalk runs during a new period, it performs a full backup. For example, if you schedule the job to run every hour but configure the period to be daily, then Backup BizTalk performs a full backup the first time it runs, and then every day at midnight.

Transaction log backups

The second step that the Backup BizTalk Job performs is MarkAndBackupLog. This step places a mark in all BizTalk databases and performs a transaction log backup every time the job executes.

The mark is the string created by using <Log Mark Name>_<Timestamp>.bak, where the <Log Mark Name> is configured on the command. This mark must be used when restoring the last log to each database.

For more information, see "Transaction Log Backups" and "Backup and Recovery of Related Databases" in SQL Server Books Online.

See Also

About Database Backup and Recovery

Scheduling Database Backups

To download updated BizTalk Server 2004 Help from www.microsoft.com, go to http://go.microsoft.com/fwlink/?linkid=20616.

Copyright © 2004 Microsoft Corporation.
All rights reserved.
© 2015 Microsoft