title: Recover Deleted tables on Sql Server 2008 R2
body: <p>I have a database in simple recovery model contains about 30 tables 
  by mistake i deleted some tables, in fact all the tables except 2 tables :( .
  when notice that, i take some steps .</p>
  
  <p>1.immediately i stopped the sql server and take a copy of mdf and ldf files, the total size of files is about  13 G.</p>
  
  <p>2.i download files from server to my locale pc to try to restore the deleting tables. </p>
  
  <ol start="3">
  <li>on the server i found an old full backup from 2 months, restored it on current infected database .</li>
  </ol>
  
  <p>i try to recover the database by this <a href="http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/" rel="nofollow">article</a> of Paul Randal. 
  but i cannot make a log backup because these reasons :
  1- database in simple recovery model .
  2- convert to full , error when try to backup log there's no full backup 
  3- when try to full and backup the attached database this contain a breaking the chain and clear the log .</p>
  
  <p>i try the ApexSQL Recover it's really good but heavy price for me and the trial recover only 10 th of the database .</p>
  
  <p>i need to find a way to recover the tables . but how ??  </p>
  
  <p><strong>Updated</strong>
  Hello ,</p>
  
  <p>i found Log Reader application [<a href="http://www.toadworld.com/products/toad-for-sql-server/w/wiki/10586.log-reader.aspx]" rel="nofollow">http://www.toadworld.com/products/toad-for-sql-server/w/wiki/10586.log-reader.aspx]</a> from dell .
  this solved my problem   </p>
  
  <p>Thanks All</p>