March 16, 2009 at 4:09 am
Accidently, i have deleted a record from Application and the same is deleted from DB..
But unfortunately, i have no good idea of the DB(ER DIAGRAM).
Is there anyway that i can retrieve the deleted record.
Regards,
SQL SERVER
March 16, 2009 at 4:19 am
sridhar.tondapi (3/16/2009)
Accidently, i have deleted a record from Application and the same is deleted from DB..But unfortunately, i have no good idea of the DB(ER DIAGRAM).
Is there anyway that i can retrieve the deleted record.
Regards,
SQL SERVER
u can use transaction log reader....APex sql is one of them
Regards,
[font="Verdana"]Sqlfrenzy[/font]
March 16, 2009 at 7:31 am
Without a log reader, and depending on the backup plan you may not have that row in the transaction log anymore, you would need to restore the database to a point in time prior to the delete. I would do this to an new database and then insert the incorrectly deleted row back into the production database from the restored database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply