February 20, 2005 at 11:13 pm
Hi everyone
Iby mistakes, all records has been deleted.
so please show me how to recover. show me step by step.
I heard about lumingent logexplorer but i dont know anything about it.
Waiting for reply.
Thanx in advance
February 20, 2005 at 11:24 pm
Hi,
Do you the backups of the database with you. If you can give the details of the backup like Full, Differential and Log backups, I can provide details how to recover the lost data.
Also what time did you delete the records ?
Is this your OLTP Server ?
February 20, 2005 at 11:25 pm
Hi, what about your DB backups? Do you have them? If so how often have you made them?
February 22, 2005 at 5:43 pm
if you're using a full recovery mode and you're regularly doing full backups as well as transaction log backups, you should be able to restore your database to another server or database and use a "point-in-time" restore. You can restore to the time just before you deleted the data in this table.
from here, you copy the data from the restored database table to the current production copy.
If you're doing transaction log backups, do a books online search for "point-in-time" recovery, or search on google for it.
If you're simply using full backups, then you'll probably have to put up with an older copy of the table from the full-backup.
Good luck.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply