How can we help you today? How can we help you today?

Feature Request: Support of Named Transactions / Marking

Hi,

Can I make a feature request for support of named transactions / marks for transaction log backups (See SQL 2000 BOL Backup and Recovery of Related Databases)

We run MS Biztalk here and the recommend/included backup method for this is a full backup of the 4/5 databases then a backup of the transaction log to a mark position inserted into each of the 4/5 databases as a single transaction.

Is this functionality available via SQL backup or could it be included in a future release?

Many Thanks

Andrew
Andrew Hodge
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi Andrew,

    I'm happy to say that this is already supported in SQL Backup. Maybe it isn't in the UI, but the backup command (or scheduled job) can be modified to include the STOPATMARK and STOPBEFOREMARK keywords in the RESTORE LOG command.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.