I'm struggling to build a SQL DB sample where I restore a marked transaction log.
What I did
After ensuring that the DB is really in full recovery mode, I made a full backup, and then a transaction log backup. I then ran a script to mark the transaction log (similar to here and here) and made another transaction log backup.
After I restore the initial full backup I try to restore the transaction log backup, using the "from file or tape" selector, as the "from previous backups of database" field is empty. It shows a transaction log to restore, but there is no marked transaction point to restore to.
What I'm trying to do
I'm an a process of moving our TFS server, but it is not a smooth ride. Apparently marked transaction logs are required to ensure that all related data are synchronised.