Is there a way to recover deleted data 1

[ksbigfoot]

We are using SQL Server 8.0
Someone just deleted 300 rows out of a table. Is there a way to find a log or recovery function to retrieve the data that was just deleted?

 

[ptheriault]

If you still have the transaction log from the database where the delete occurred you could use a tool like log explorer by lumigent to get those rows back.

What is the recover model of your database. If it's simple there will be no way to get back the data!

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ksbigfoot]

Howdy Paul,

Thanks for the info, star to you.
We are purchasing the software from lumigent.

Thanks again for pointing me in the right direction.

Kelly

 

[ksbigfoot]

Howdy Paul,

Wow, the Log Explorer from lumigent is remarkable.
It is so easy to use, I was able to restore my data in minutes and that includes the time to also install the software.

Thanks again,
ksbigfoot

 

[ptheriault]

Yes it is. It has save my butt more than once!


- Paul
- If at first you don't succeed, find out if the loser gets anything.