title: How to recover data from truncated table
body: <p>while going though sql server interview question in book of mr. shiv prashad koirala. i got to know that, even after using truncate table command the data can be recovered.</p>
  
  <p>please tell me how can we recover data when data is deleted using 'delete' command and how can data be recover if data is deleted using 'truncate' command.</p>
  
  <p>what i know is that when we use delete command to delete records the entry of it is made in log file but i don't know how to recover the data from and as i read that truncate table not enters any log entry in database then how can that also be recovered.</p>
  
  <p>if you can give me any good link to do it practically step by step than that will be great help to me. </p>
  
  <p>i have got sql server 2008.</p>
  
  <p>Thanks</p>