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 |
|
chandak76
Starting Member
3 Posts |
 Posted - 2005-08-29 : 09:10:03
|
| My database was overwritten by a new blank database,Is there a way i can recover my data coz all can find is a temp.mdf with some code and there I can see some of my data if i open it using notepad.I donn't have any backups.Is there a way that temp file can help?I've tried some data recovery but it didn't help.Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-29 : 12:21:35
|
| How was the database overwritten?I can only think of a couple of ways:1) Drop the database and create a new one with the same name2) Restore a backup over the existing one3) Attach database files in place of the original oneIn all three of those there will be no route to get the original database back.Do you have anything that is backing up the whole server, perhaps?Sorry, but you do need to back your databases up. There is a setting in the Database Maintenance Wizzard that will back up ALL user databases - so as soon as a new database is created that Backup plan will include the new database. That would protect you from this sort of scenario.Kristen |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-29 : 12:33:26
|
| Your only recourse is to send the drive to a specialized data recovery firm who may be able to read any disk blocks that have not yet been reused and piece together some of the database. That way you may get a small amount of the data back but it will cost you serious $$$ to do so.Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
chandak76
Starting Member
3 Posts |
Posted - 2005-08-30 : 09:10:15
|
| is there anything i can do with the temp.mdf or master.mdf coz all the data recover guys could only find a blank database and the two files i mentioned.I can see the temp.mdf containing some of the data in the database and some code. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-30 : 09:31:01
|
| temp.mdf is just going to contain data from querries that needed "working space", isn't it?No telling a) what vintage those querries were, or b) how complete the data is that was in those querriesBut I may have got that wrong and your chances are better than that - I hope so for your sake!Kristen |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-31 : 12:18:07
|
| Basically the answer's no - you've lost everything unless you want to pay major $$$ to a specialized recovery company.Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
database overwritten