Roxanne25
asked on
Recovering Deleted .sql File
Hello, I am guessing this is hopeless but I'm really desperate and need some advice. I'm pretty sure ya'll are gonna tell me I'm screwed...but I'm still gonna ask.
I just got a new laptop at work and somehow, they did not copy over a .sql file I needed and instead...deleted it! It wasn't even in the recycle bin... it was just wiped off.
I went online and downloaded WinUndelete and did a search for the file on my old desktop. I found it... recovered it. But it was in "poor" condition, so I'm guessing that's why when I try to open it, it goes into Notepad and all I see is a bunch of garbage. The file recovered is 29KB and is recognized as a sql server file.
This procedure took me like 4 months to write and I'm desperate to get it back. Is there a better recovery program I can use or some way I can repair the sql file?
Thanks in advance.
I just got a new laptop at work and somehow, they did not copy over a .sql file I needed and instead...deleted it! It wasn't even in the recycle bin... it was just wiped off.
I went online and downloaded WinUndelete and did a search for the file on my old desktop. I found it... recovered it. But it was in "poor" condition, so I'm guessing that's why when I try to open it, it goes into Notepad and all I see is a bunch of garbage. The file recovered is 29KB and is recognized as a sql server file.
This procedure took me like 4 months to write and I'm desperate to get it back. Is there a better recovery program I can use or some way I can repair the sql file?
Thanks in advance.
Also if this was windows xp and a restore point was set , it may help to go back to that point in time.
ASKER
ok I will give norton a try... I thought disk doctor only did like disk defragging?
They have a search and rescue tool as well.
ASKER
Oooooh.... it says it has a system restore available for the date I need. I didn't know our work computers were doing restore points.... will that actually restore the files that were deleted?
I just realised that it will not recover deleted files. That applies only to the win xp settings.
ASKER
:( You got my hopes all up.
ASKER
I can't find anything on the symantec site called norton disk doctor... do they still make it or is it bundled with another application?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is there any way I can repair the file that I retrieved? Windows recognizes it as a sql server file....but when I try to open it, it goes to Notepad and is all garbage.
It means that the file may have been damaged or incorrectly recovered.
Your best bet is to use one of the tools from Pc world.
Your best bet is to use one of the tools from Pc world.
ASKER
I tried... its not finding anything... or the tool doesn't allow me to search for a .sql file...
Where does SQL Server store auto recover files?
Where does SQL Server store auto recover files?
Hmm..that sucks.
As far as I know SQL server does not store any auto recover files, they are stored on the hard drive.
As far as I know SQL server does not store any auto recover files, they are stored on the hard drive.
ASKER
They are actually stored in a backup folder but they aren't historical... There should be some wierd temp directory that it saves the auto recover stuff to though cause it has to do it in case of an improper shut down.
Oh well, thanks for the help!
Oh well, thanks for the help!
You are right..this post might help..talks about the temp folder.
http://www.sqlservercentral.com/Forums/Topic500268-149-1.aspx
http://www.sqlservercentral.com/Forums/Topic500268-149-1.aspx
There are a lot of tools which promise a lot and do not deliver, instead their recovery process messes up things.