Recover The data After Deleting

• su_kumar11

  SSCommitted

  Points: 1675

  More actions

  October 5, 2009 at 5:06 am

  #156286

  Hi,

  I have a query.

  Suppose If I dont have backup of database.

  And I have deleted some data from the table or droped a table.Is

  there any possibilty to recover the data from the table or drop table?

  Pls help me to solve above problem.

  Thanks,

  Sunil Kumar

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  October 5, 2009 at 5:08 am

  #1061640

  su_kumar11 (10/5/2009)

  ---

  Hi,

  I have a query.

  Suppose If I dont have backup of database.

  And I have deleted some data from the table or droped a table.Is

  there any possibilty to recover the data from the table or drop table?

  Pls help me to solve above problem.

  Thanks,

  Sunil Kumar

  Do you have any backups at all, including log backups. what is the recovery model of the database.

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 5, 2009 at 5:24 am

  #1061643

  If you don't have any backup at all, then the chances of getting anything back are exceedingly slim. Regardless of recovery model, if there has never been a backup then the log is in auto-truncate mode, which means that inactive log records will be discarded after a checkpoint (about every minute).

  You can try a log reader, ApexSQL sells one, as do a couple other companies, but they are not cheap.

  Is this a theory question or have you dropped a table that you shouldn't have?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Sergey Vavinskiy

  SSCarpal Tunnel

  Points: 4469

  More actions

  October 5, 2009 at 6:00 am

  #1061653

  As was mentioned you can use ApexSQL Recover tool, which was specifically designed to recover a lost data due to DELETE, TRUNCATE, DROP operations.

  http://www.apexsql.com/sql_tools_recover.asp

• apogoreliy

  SSC Journeyman

  Points: 94

  More actions

  July 4, 2015 at 7:55 am

  #1810268

  That's not a responce to a query of su_kumar11 directly, he asked 5 years ago 🙂 But for those who will have such an issue. There is a way to recover missing data by using Transaction Logs and LSNs (Log Sequence Numbers). There are few steps what you need to do - http://sqlbak.com/blog/recover-deleted-data-in-sql-server/[/url]