up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
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
feedback

migrated from stackoverflow.com Mar 29 at 8:33

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.