3a940e6f   
   From: esquel@sommarskog.se   
      
   xo (xo5555ox@gmail.com) writes:   
   > I got a full db backup file and one log backup which contains about 8   
   > hrs worth of tx  (tx backup once per hr between 6:30AM - 2:30PM) .   
   > First I restored the full backup and then I restored the tx log up to   
   > 11:30AM and tried to leave the db as standby as well as non-   
   > operational so I can restore more tx from the same log backup, but I   
   > couldn't. I got the above messages.   
      
   So you say that you first did:   
      
      RESTORE DATABASE db FROM DISK = 'somefile.bak' WITH NORECOVERY, REPLACE   
      
   Then you did:   
      
      RESTOTE LOG db FROM DISK = 'trnfile.bak' WITH NORECOVERY,   
                                               STOPAT = '20100714 11:30'   
      
   And this succeeded successfully?   
      
   Next you tried:   
      
      RESTOTE LOG db FROM DISK = 'trnfile.bak' WITH NORECOVERY   
      
   Using the same file as before, and this failed?   
      
   I tried to emulate this situation, and it worked. That is, I was able to   
   apply the same transaction log twice, with different values for STOPAT.   
      
   I think you need to verify that you use the correct file, and also that   
   you used the correct file number. (The WITH FILE option.)   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)