title: restore database from transaction log problem
body: <p><p>
  I'm following instructions <a href="http://msdn.microsoft.com/en-us/library/ms186858.aspx#restoring_transaction_log_to_mark" rel="nofollow">here</a> to save database state and restore it from any state i previously saved. I cannot however get the RESTORE given in the example there working. I always get a message </p>
  
  <blockquote>
    <p>This log file contains records logged
    before the designated mark. The
    database is being left in the
    Restoring state so you can apply
    another log file.</p>
  </blockquote>
  
  <p>I think the problem is with the FILE version, but from what I see in the example, it should be N in DB and N-1 in Log, and that's how I always set it. Any help would be appreciated.</p>