1

I have run delete wrong row from table how can i get back that row.
I am using sqlserver 2008

delete  from tblpayment where Payment_OrderID=11122
Himanshu
  • 31,810
  • 31
  • 111
  • 133
Chhatrapati Sharma
  • 605
  • 4
  • 9
  • 18
  • I'm afraid you can't unless you have a backup. – kyooryu Aug 30 '12 at 12:00
  • Your question sounds similar to [How to recover deleted rows from SQL server table?](http://stackoverflow.com/questions/3540729/how-to-recover-deleted-rows-from-sql-server-table) Just have a look and I believe that it may help you , specially the [external link](http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/) specified over there. – Niladri Biswas Aug 30 '12 at 14:50
  • see also: http://dba.stackexchange.com/questions/995/how-do-i-get-back-some-deleted-records – Kev Sep 01 '12 at 03:18

1 Answers1

0

NO. You cannot do that easily in sql server unless its not done within a transaction.

Best option is to restore from backup

edorian
  • 38,542
  • 15
  • 125
  • 143
Joe G Joseph
  • 23,518
  • 5
  • 56
  • 58