August 27, 2010 at 1:30 pm
Hello our experts,
A very bad situation happened in my company, we were put a SQL DB in a specific server, so the distribution team CUT it from this server to another specific server, then by mistake they deleted all records from all tables in this DB when they didn't have any backup for it (also note that they empty the log file for this DB from a month), :crazy:, So we tried a lot to use Recover My Files program to restore the CUT DB from the first server, but we failed as this tool recovered some files but not this specific DB!!, So Please is there any specific solution, I believe that our experts here should know any solution regarding that..txtPost_CommentEmoticon(':-)');
- Note also that we installed Apex SQL Recover 2008, but it seems that it restores some records from the tables in the empty DB from the log file but it needs an activation key, when I haven't this 1700$ to activate it.. Please help
August 27, 2010 at 2:09 pm
If you don't have the .mdf file for the database, and there's no available backup and the file recovery tools can't bring it back, then there is no way to get the database back. Was there a file system backup taken at any time that might have picked this up?
August 27, 2010 at 2:48 pm
No, I have the .mdf and .ldf but for the empty DB, and I don't think that we have any backup for this DB before
August 27, 2010 at 3:06 pm
I assume you mean deleted.
If you don't have a backup, and you don't have the older mdf files, you're stuck. I would take a log backup immediately, and save that.
Your only change of restoring there easily is to buy a tool like the log tool from Apex or one of the other vendors, and use that. You could potentially use DBCC LOG to read through the log, but it will not be easy, and there isn't a log of help you'll get. Here's a thread that could get you started:
http://www.sqlservercentral.com/Forums/Topic628365-357-1.aspx#bm875729
As mentioned there, the log isn't designed for humans. Companies put a lot of effort into building a tool to read it, and if the data is important, pay them for the tool.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply