how to get back table with data aafter deleting it

• rohinaggarwal

  Grasshopper

  Points: 19

  More actions

  February 3, 2004 at 1:47 am

  #85447

  my developer has deleted the table from enterprise manager and i  had last day backup of database now i want to restore the table to the point from where it was deleted I want full contents of table when it was deleted i dont have todays backup how to proceed ?

• mccork

  SSC-Insane

  Points: 22288

  More actions

  February 3, 2004 at 4:13 am

  #492589

  You can proceed (in a complicated manner) if the database was in full or bulk-logged recovery mode AND you've taken regular tlog backups.

  If the table was in simple recovery mode then I'm afraid you're stuck.  The last full backup is your only choice... restore it to another database and DTS the data across.

   

  
  Cheers,
  - Mark

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 3, 2004 at 4:29 am

  #492592

  If that happened on a production box, I suggest reviewing your security and permission policy and have an interview with that programmer

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  February 3, 2004 at 7:41 am

  #492614

  As McCork states if you have full recovery activated then

  backup current log

  backup full database (just in case)

  restore database from previous backup (last day backup)

  roll forward log

  If that happened on a production box, I suggest reviewing your security and permission policy and have an interview with that programmer

  Frank, is that your halo slipping but then you've never done that eh!

   

  Far away is close at hand in the images of elsewhere.
  Anon.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 3, 2004 at 7:50 am

  #492616

  O tempora, o mores

  To every thing there is a season

  From The Bible, Old Testament Ecclesiastes iii

  To every thing there is a season, and a time to every purpose under the heaven:

  • A time to be born, and a time to die; a time to plant, and a time to pluck up that which is planted;
  • A time to kill, and a time to heal; a time to break down, and a time to build up;
  • A time to weep, and a time to laugh; a time to mourn, and a time to dance;
  • A time to cast away stones, and a time to gather stones together; a time to embrace, and a time to refrain from embracing;
  • A time to get, and a time to lose; a time to keep, and a time to cast away;
  • A time to rend, and a time to sew; a time to keep silence, and a time to speak;
  • A time to love, and a time to hate; a time of war, and a time of peace.

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]