how to retrive deleted record

Question

Hi friends pls help me! unexpected I deleted 87 record from one table. is there any possible to retrive those record from database? please give me sample query urgent.... Thanks

Manish Dwivedi · Answer

Hi Kavitha Take the reference of this article. http://www.spaceprogram.com/knowledge/sqlserver_recover_from_deleted_log.html

Niradhip Chakraborty · Answer

If you had started the transaction then you can rollback.if its not committed.. If you had not started and that data was very imporatant.then you should ask your administrator to restore it from backup If you have a database backup and you believe that thos records will be included in the database backup then restore the backup with another name and compare the appropriate tables to identify the missing records. Then run a cross database query to insert the deleted records.