Recovery deleted row

Dear all,
if i delete a row in a table accidently , how can i recover that rows
in case 1: just delete it a few second before
in case 2: delete it and add several rows after deleted rowsSQL Server doesn't provided a 'undelete' method. You will have to read the
transaction log using commands like DBCC LOG, or fn_dblog. But there isn't
much official documentation available about these commands. Another
alternative is to use a tool like Lumigent Log Explorer that can recover
data from the transaction log, as long as that transaction is in the
transaction log.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:CF2DC4B2-3CB8-47BA-B200-E91D03890E07@.microsoft.com...
Dear all,
if i delete a row in a table accidently , how can i recover that rows
in case 1: just delete it a few second before
in case 2: delete it and add several rows after deleted rows|||> Dear all,
> if i delete a row in a table accidently , how can i recover that rows
> in case 1: just delete it a few second before
> in case 2: delete it and add several rows after deleted rows
Backup is your friend here.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Joe
Vyas has already answered your question.
I'd like to add if do soem testing (delete,insert,update) on QA add BEGIN
TRAN before a statement and make sure that you did right thing and then
COMMIT
BEGIN TRAN
delete from Table
10000000 (rows) affected
Mistake!!!!!!!!!!!!!!!!!!!
Rollback Tran
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:CF2DC4B2-3CB8-47BA-B200-E91D03890E07@.microsoft.com...
> Dear all,
> if i delete a row in a table accidently , how can i recover that rows
> in case 1: just delete it a few second before
> in case 2: delete it and add several rows after deleted rows|||Recovery is not a method if there have some rows added after the row is
deleted!|||If you had a backup, then you could at least restore it as a different
database, and selectively copy the required rows back into your database.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:2D3C1228-60E5-4326-A55E-DF964EA474BD@.microsoft.com...
Recovery is not a method if there have some rows added after the row is
deleted!|||Hi Joe
>if i delete a row in a table accidently , how can i recover that rows
Accidents can ONLY be prevented with precautions.
You can write a trigger to avoid deletion using @.@.rowcount, if you dont have
regular deletions. You can use this to specific user also.
If you find that official regular deletions are inevitable(practically true)
use triggers to add to to history tables so that you can easily retrieve the
row you want.
Regards
R.D
"Narayana Vyas Kondreddi" wrote:

> If you had a backup, then you could at least restore it as a different
> database, and selectively copy the required rows back into your database.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:2D3C1228-60E5-4326-A55E-DF964EA474BD@.microsoft.com...
> Recovery is not a method if there have some rows added after the row is
> deleted!
>
>