SQL Server Performance Forum – Threads Archive

Delete

Please help me out how to get back the deleted rows. i know that it is a logged operation. By mistaken i have removed some records in the table.
thanks
Rao

---

if you have transaction log backup, restore it using stop At option. Ref How to: Restore to a Point in Time (Transact-SQL) in BOL Madhu

---

for this ur recevry model should be full instead of simple —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

True and best thing is you can restore the backup as a different database and use the DTS to select those deleted rows. Having the RESTORE operation from last good know backup will also loose the database updates since last backup, in this case I feel DTS is only saviour. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

As Satya mentioned restore as different db on the same server if you have free space then you can use CROSS DB join to get the data.
If you are restoring on to different server then you may need to use SSIS/DTS or linked server to get the data.
MohammedU.
Moderator
SQL-Server-Performance.com

---

Thanks a lot your suggestions

---

And other suggestion is you should always do Updates and Deletes in TEST server or TEST tables
Then you can apply in production Madhivanan Failing to plan is Planning to fail

---

]]>