Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Thiyagu23061990
Starting Member
1 Post |
 Posted - 2014-12-11 : 11:17:17
|
| I have an accidentally delete the database. there is no backup file for that database in this year, I want to recover the deleted database. Please give an best ideas to recover the database. We have tried tools,such tools are repairing the corrupted mdf file. Please give an best suggestion to recover the database |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-11 : 12:06:11
|
| look for tools that allow you to find deleted files (google it, there are lots of them). Use those tools to find the .mdf and .ldf files and rebuilt their directory entries. Then, try to attach those files as a new database.Good luck! |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2014-12-12 : 05:01:02
|
| If you have deleted the database file then you need to look for data recovery software not mdf repair software. A repair software repairs the corrupt or damaged file not recover the lost or deleted file. |
|
|
|
RobinSQl
Starting Member
2 Posts |
Posted - 2015-02-02 : 01:19:54
|
| Which version of sql server are you using? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-02-02 : 01:35:41
|
| Was the database offline by any chance when you dropped it? If so, there may be a possibility the files exist, have you checked on the drives?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
newballance989
Starting Member
3 Posts |
Posted - 2015-02-09 : 02:10:44
|
| unspammed |
|
|
|
Lincolnburrows
Yak Posting Veteran
52 Posts |
Posted - 2015-05-28 : 04:44:38
|
| If you deleted all the database files and haven't backed them up anywhere the only hope would be to stop using the server immediately and try some file system recovery software that can recover deleted files |
|
|
|
|
|
|
Deleted Database