- Posts: 53
- Thank you received: 0
Recovering overwritten database
19 years 11 months ago #9452
by defsoul
Replied by defsoul on topic Re: Recovering overwritten database
I have got a file tempdb.mdf which I tried to open with notepad and I can see some of the data there,could it be that this could be the data base that Im looking for,it is about 8mb,the database that that i have which does not have any data is about 3mb.
19 years 11 months ago #9464
by DaLight
Replied by DaLight on topic Re: Recovering overwritten database
tempdb.mdf is a system database created automatically by MSSQL to hold temporary objects. The fact that it contains some of your data is coincidental.
A couple of questions?
1. Are there actually any other *.mdf files in your SQL Data directory? 2. Do you know for a fact that your database has been overwritten?
A couple of questions?
1. Are there actually any other *.mdf files in your SQL Data directory? 2. Do you know for a fact that your database has been overwritten?
19 years 11 months ago #9481
by defsoul
Replied by defsoul on topic Re: Recovering overwritten database
Yes Im sure the data was overwritten coz I can ge it anywhere else,
There are other mdf
1.Master.mdf
2.Model.mdf
3.msdb.mdf
4.tempdb.mdf
5. my database.mdf
There are other mdf
1.Master.mdf
2.Model.mdf
3.msdb.mdf
4.tempdb.mdf
5. my database.mdf
19 years 11 months ago #9482
by DaLight
Replied by DaLight on topic Re: Recovering overwritten database
You never got back on whether Shadow Copy is enabled, because if it is you can use it to access previous versions of "my database.mdf"
19 years 11 months ago #9486
by defsoul
Replied by defsoul on topic Re: Recovering overwritten database
Unfortunatly it was disabled,but Ihave enabled it and I Never new how it works until now, Thanks
19 years 11 months ago #9488
by DaLight
Replied by DaLight on topic Re: Recovering overwritten database
Sorry about that defsoul, I have no more ideas apart from suggesting low-level data recovery techniques which I'm not proficient in.
Time to create page: 0.090 seconds