What are the challenges you face when working across database platforms? Take the survey

Feature Request: Support of Named Transactions / Marking

Andrew HodgeAndrew Hodge Posts: 132
edited August 7, 2008 4:34AM in SQL Backup Previous Versions

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



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
Sign In or Register to comment.