Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Mar 29 '12 at 8:33

This question came from our site for professional and enthusiast programmers.

Why the close vote? Is this the wrong forum? –  Peet Brits Nov 16 '11 at 13:22
Serverfault of DBA are going to be better placed to answer this, they are sistersites, voting to migrate the question to serverfault –  Andrew Nov 20 '11 at 22:00
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.