September 26, 2001 at 11:16 am
On SQL Server 2000.
I don't know if this is possible, though I am only a developer, and don't have a great deal of knowledge about backups.
Some data was inserted into a table (we NEED this data!) and an old entire backup was restored over the existing dB, unfortunately this occured a few hours before our scheduled backup was to occur. Is it possible to recover the data from the table we need? (Admin said no chance, though I would like to make sure)
I am not sure what options were used in the restore of the dB, though I can find out.
September 26, 2001 at 1:34 pm
Your only chance might be with LogExplorer by Lumigent. Depends on if the log has been overwritten/truncated yet. Wouldn't get my hopes up.
Andy
September 26, 2001 at 5:29 pm
Were you backing up transaction logs of the database ?. If so restore backup befor insertion of data and restore each transaction log until you reach the time the data was inserted approx or database overwritten.
September 28, 2001 at 2:36 am
Thanks for that. The logs were truncated.
But I got LogExplorer anyway, it will be very useful.
Thanks for your help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply