Feature Request: Support of Named Transactions / Marking

Andrew HodgeAndrew Hodge Posts: 132
edited August 7, 2008 4:34AM in SQL Backup Previous Versions
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.