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
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
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Blocked AccountPosted Aug 27, 2008, 2:06 AM
Hi Kavitha,
Take the reference of this article.
http://www.spaceprogram.com/knowledge/sqlserver_recover_from_deleted_log.html
Niradhip ChakrabortyPosted Aug 27, 2008, 1:55 AM
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.