Rolling Back deleted Data

6 Jan 2006 4:56 AM

Yogesh

Hi Guys

If i deleted a table data without taking query in ant transaction. Could it
possible to recover data ?

For Example
I wrote query

Delete From Table_A where Column_A ='SomeValue'

but i forgot to add another condition and delete more recordes than needed

now i want to roll back this query ...

Thanks in Advance

Yogesh

6 Jan 2006 6:22 AM

David Gugick

Yogesh wrote:
Show quote

> Hi Guys
>
> If i deleted a table data without taking query in ant transaction.
> Could it possible to recover data ?
>
> For Example
> I wrote query
>
> Delete From Table_A where Column_A ='SomeValue'
>
> but i forgot to add another condition and delete more recordes than
> needed
>
> now i want to roll back this query ...
>
> Thanks in Advance
>
> Yogesh

You can use a log read to roll back the changes as long as your
transaction log is intact (i.e. not using simple recovery). The other
option is restore from backup or reinsert data manually if you know what
was deleted. There are log readers from: http://www.logpi.com/ and
www.lumigent.com.

--
David Gugick
Quest Software
www.quest.com

6 Jan 2006 6:24 AM

SriSamp

If your delete was within a transaction, you can use ROLLBACK. But, if you
have committed the data (either intentionally or implicitly), then you
cannot recover it back.

--
HTH,
SriSamp
Email: sris***@gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp

Show quote

"Yogesh" <yog***@Parashar.com> wrote in message
news:u4Eaz2nEGHA.272@TK2MSFTNGP10.phx.gbl...
> Hi Guys
>
> If i deleted a table data without taking query in ant transaction. Could
> it
> possible to recover data ?
>
> For Example
> I wrote query
>
> Delete From Table_A where Column_A ='SomeValue'
>
> but i forgot to add another condition and delete more recordes than needed
>
> now i want to roll back this query ...
>
> Thanks in Advance
>
> Yogesh
>
>

6 Jan 2006 7:36 AM

Aaron Bertrand [SQL Server MVP]

Ad hoc deletes without a BEGIN TRAN and verification are never a good idea.
Do you have a good backup? If not, start implementing a backup regimen
RIGHT NOW, then see the following article, where I demonstrate use of a 3rd
party product to do exactly what you need to do: undo something stupid.

http://www.aspfaq.com/2449

Show quote

"Yogesh" <yog***@Parashar.com> wrote in message
news:u4Eaz2nEGHA.272@TK2MSFTNGP10.phx.gbl...
> Hi Guys
>
> If i deleted a table data without taking query in ant transaction. Could
> it
> possible to recover data ?
>
> For Example
> I wrote query
>
> Delete From Table_A where Column_A ='SomeValue'
>
> but i forgot to add another condition and delete more recordes than needed
>
> now i want to roll back this query ...
>
> Thanks in Advance
>
> Yogesh
>
>