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 |
|
oguzkaygun
Yak Posting Veteran
53 Posts |
 Posted - 2009-06-06 : 08:54:14
|
| hii have one corruption mdf file. it is MS SQL 2000 file.can you explain me step to step how can i recover it ?or i tried demo Stellar Phoneix SQL Recovery Software and i can see my records. but it is so expensive. is there free software like it ?or where can i find one crack software like it ? can you give me link ?Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-06-06 : 10:30:35
|
| When you say 'corrupt' exactly what do you mean? What have you tried, what doesn't work, what errors are you getting?In my experience, I have not found a data recovery tool that worked very well and I have never found a cheap one. Those thing are not easy to write.I'm going to pretend I didn't hear you asking for illegal, stolen software.--Gail ShawSQL Server MVP |
 |
|
|
oguzkaygun
Yak Posting Veteran
53 Posts |
Posted - 2009-06-06 : 13:53:17
|
| hithis file is MS SQL 2000 file. and only *.mdf file.i have SQL 2008 at my computer. and when i try to attacht *.mdf, i have message that *.log cant be found.what can i should ?if i can open *.mdf at SQL 2008, i can turn it for SQL 2000 ?Thanks |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-06-06 : 15:28:50
|
| Try using sp_attach_single_file_db on the SQL 2000 server. If it gives errors, post the complete error message here.If you upgrade the DB to 2008, you will not be able to use it on SQL 2000 again. Upgrade is one-way and irreversible. If you don't mind that, you can try to attach it to the 2008 server. Use CREATE DATABASE ... FOR ATTACH_REBUILD_LOG (full details in Books Online)--Gail ShawSQL Server MVP |
|
|
|
alkeshonnet
Starting Member
1 Post |
Posted - 2009-07-07 : 01:36:27
|
| I have same kind of problem if any body can help usAlkesh |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-07 : 04:07:20
|
quote:
Originally posted by alkeshonnet
I have same kind of problem if any body can help us
Please can you start a new thread and describe exactly what problems you are having in detail.Thanks--Gail ShawSQL Server MVP |
|
|
|
imranpk8
Starting Member
3 Posts |
Posted - 2009-09-04 : 15:30:07
|
| i have SQL server 2000...its Data base file name and extention has changed automatically...may be due to some virus... now name are just like v0fâ¦.faf ... file extention also has changed... files are like garbage....and one empty folder has also created automatically with those file name is :fnf3¦n+.n- ...like garbage...it is empty...Anti virus software did detect any virus.. Norton or AVG... plz help me..how i can retrieve my files in original fomat ? i have a lot of important data in it..Thanks |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
corruption *.mdf file