SQL Server Performance Forum – Threads Archive
DeletePlease 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.
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
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
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.
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