title: Recover deleted record in SQL Server
body: <p>I accidentally deleted a row in a table and want to restore it. I've found a solution here: <a href="http://www.krishantha.net/index.php/database/sql-server/3-how-to-recover-deleted-records-from-ms-sql-server" rel="nofollow"><em>How to recover deleted records in MS SQL server</em></a></p>
  
  <p>I've tried to restore database from backup taken after delete. But I can't restore database with STOPAT option:</p>
  
  <pre><code>RESTORE LOG database FROM  DISK = N'X:\database.BAK' WITH
  STOPAT = N'2011-02-12T00:00:00', RECOVERY
  </code></pre>
  
  <p>I have following error:</p>
  
  <pre><code>Msg 3117, Level 16, State 4, Line 1
  The log or differential backup cannot be restored because no files are
  ready to rollforward.
  Msg 3013, Level 16, State 1, Line 1
  RESTORE LOG is terminating abnormally.
  </code></pre>