December 26, 2007 at 3:39 am
Hi all,
Is it possible to recover a deleted row from my database if i don't have any back up made.
December 26, 2007 at 7:08 am
Hi,
I never found how, but I think it's not possible.
It's better if you have a full backup and try to do a restore 'point-in-time' or if you have a snapshot
December 26, 2007 at 9:50 am
If you have a log reader and you haven't been running in simple mode, then you can read the transaction log (live or backup) with one of the tools from Lumigent or ApexSQL.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 26, 2007 at 1:02 pm
If the recovery mode of your database is set to Full, you may try to restore your database to the point just before you deleted your record.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply