Recover Deleted rows in SQL Server 2000

• Agile

  Ten Centuries

  Points: 1153

  More actions

  September 2, 2009 at 7:36 pm

  #95772

  Guys I need help badly on my sql server,

  Last time I asked about how to trace deleted data so now I will ask if there's a possibility to recover deleted data?

  Please need help badly, I really need that data for our company.

  Thank you in advance

  Thanks,
  Morris

• WayneS

  SSC Guru

  Points: 95460

  More actions

  September 2, 2009 at 7:52 pm

  #1048510

  Restore your backup to a different database, on the same server if there is enough space. Then you can do an insert from the new database to the table where the data was deleted.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• Agile

  Ten Centuries

  Points: 1153

  More actions

  September 3, 2009 at 4:11 am

  #1048627

  Thanks for the reply

  I already did that but unfortunately the record I want is not on that backup.

  Can I use .Log? to Rollback deleted rows.

  Thanks,
  Morris

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 3, 2009 at 4:38 am

  #1048640

  Damien (9/3/2009)

  ---

  I already did that but unfortunately the record I want is not on that backup.

  Got an older backup?

  Can I use .Log? to Rollback deleted rows.

  You can try a log reader tool like RedGate's SQL Log rescue, but it depends on how long ago the deletes were done and what recovery model the DB is in.

  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