Feature Request: Support of Named Transactions / Marking
Andrew Hodge
Posts: 132
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
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
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.