Help me save the data! help me fix the MDF files. Please come in!

[dordort]

Hi. few days left after i posted this thread: http://forum.ragezone.com/f460/my-c...einstall-mssql-2000-with-all-the-data-490255/

Now i succesfully recovered my computer files with the software "GetDataBack for NTFS" into another hard disk that i bay. some of the files recovered not good, its damaged and some of the files its ok. the CentOS vmdk file was 100% fine, but in my bad luck i got the MDF files damaged. :S i tryed another recover software and the same problem. i got the MDF and LDF files, all looks fine like this:

But, when im trying to attach MDF file (I tryed all of my files.) im getting this error:

So that's mean the files its damaged somewhere :S there is something to do about this? it is very important. theres a way to fix that files? :X

Thanks alot,
Dor.

 

[chumpywumpy]

Hi Dor

Fixing mdf files that weren't detatched correctly can be done but is not always successful. The procedure is quite tricky too but it is done like this...

To view the content, you need to sign in or register

 

[dordort]

Hi chumpy, thanks for replying. i tryed this and the first query succeded, but when i run this query:

dbcc rebuild_log(fake,"c:\fake_log.ldf")
go
dbcc checkdb(fake)
go

(fake_log its the GAMEDB_log after rename)

it writing back this:

Server: Msg 5180, Level 22, State 1, Line 1
Could not open FCB for invalid file ID 26624 in database 'fake'.
[Microsoft][ODBC SQL Server Driver]1כשל קישור של תקשורת

Connection Broken

and the same error (Could not open FCB for invalid file ID 26624) when open fake Tables in Enterprise Manager. (and ofcurse Tables its empty in this table.....)

Thanks :S

 

[chumpywumpy]

I suspect this is down to another problem i have found in the databases, certain tables have invalid row sizes in the server 25 dbs (which we use). I'm still trying to work a way arund this for the db upgrade i have planned.

This might help or it might not. Not really sure what else to suggest though.

To view the content, you need to sign in or register

 

[dordort]

I suspect this is down to another problem i have found in the databases, certain tables have invalid row sizes in the server 25 dbs (which we use). I'm still trying to work a way arund this for the db upgrade i have planned.

This might help or it might not. Not really sure what else to suggest though.

To view the content, you need to sign in or register

I succesfully change 'max degree of parallelism' from 0 to 1 on 'master', but i still getting the 5180 Error Msg. that's mean that my data gone? :S

 

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

 

[dordort]

Pretty yes... next time try to avoid this by having daily backup,

Damn it :$: ok thanks for the help, if you can cypher give me some guide how to backup the databases correctly.

 

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

 

[dordort]

Well all you need to do is right click on target database, and make a backup from the menu, can`t seem to remember the name.

Lol i know this =P or just copy the MDF and LDF files. i mean if theres something professional that backup the files automatticaly every few hours, some tool or something like that.

 

[chumpywumpy]

In MSSQL 2000 first you create a backup device under Management->Backup (you will need one backup device for each database really). Now right-click the database and go All Tasks->Backup database, select the backup device to back up to and then tick "schedule" at the bottom to set the scheduling options.

Copying mdf and ldf files is not the best way to do it as it can lead to problems. If you are going to do it that way make sure you right-click the databases and detatch them before backing them up.

 

[dordort]

In MSSQL 2000 first you create a backup device under Management->Backup (you will need one backup device for each database really). Now right-click the database and go All Tasks->Backup database, select the backup device to back up to and then tick "schedule" at the bottom to set the scheduling options.

Copying mdf and ldf files is not the best way to do it as it can lead to problems. If you are going to do it that way make sure you right-click the databases and detatch them before backing them up.

Ok thanks =]. oh its so bad luck that i loose the data :S