Hi Gail,

"The backup started after the commands started, so as long as they finish before the backup finishes, they will be in the restored database" sort-of suggests that the start-time of the transaction vs start-time of the backup dictates whether the transaction will be included.

My understanding was that, independent of when a transaction starts, it will be included in the restored database if it completes before the backup completes i.e. transaction COMMIT is determinant (and transaction BEGIN is irrelevant).

Example reference

"Use a Full Database Backup to Restore the Database

You can re-create a whole database in one step by restoring the database from a full database backup to any location. Enough of the transaction log is included in the backup to let you recover the database to the time when the backup finished. The restored database matches the state of the original database when the database backup finished, minus any uncommitted transactions." (emphasis added)

Chris