• I thought that the backup would complete successfully, regardless of the transaction. It could have been a nice feature to be able to :

    - start a transaction

    - do some changes to the database that you want to test later without interfering other users

    - take a backup (it shouldn't participate in the transaction)

    - rollback the transaction to remove your changes (not the backup)

    - restore the backup with a new name (or a virtual restore with Red gate Virtual Restore)

    - do your testing in your copy of the database

    But the uncommitted changes would't be in the backup anyway, so the feature wouldn't work anyway.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform