I'm a stupid man - Erase a database part

gunthergunther Member Posts: 15
edited 2006-10-13 in Navision Attain
Hi every body...

I'm a stupid man, but I need some help, your are my last chance...

I had a big database 20 Go (space use 17 Go) and (because I'm stupid) I have extend it with a little part (100 Mo) just for test...

And of course I have erase the fdb file of 100 Mo... because I forgot what it is... 8-[

Now my problem, I think you understand, that I can't open my database... it need the part I erase (I've try some recovery software, it not work for my file)

Help !!! If you know a issue !

Thank in advance... O:)

Comments

  • DenSterDenSter Member Posts: 8,304
    I hope you made a backup because I don't think you can recover that.
  • Captain_DX4Captain_DX4 Member Posts: 230
    Um, yeah... That would be bad. As bad as if you'd deleted the main 20G file...

    Your only choice that I can see is if you have a backup, you can create a brand new database and restore the data from the backup. A long shot could be to check with Microsoft to see if an engineer of theirs could edit the database file with any special-magical tool and make it forget about the 100M portion, but this seems highly unlikely to work.
    Kristopher Webb
    Microsoft Dynamics NAV Developer
  • PhennoPhenno Member Posts: 630
    Um, yeah... That would be bad. As bad as if you'd deleted the main 20G file...

    Your only choice that I can see is if you have a backup, you can create a brand new database and restore the data from the backup. A long shot could be to check with Microsoft to see if an engineer of theirs could edit the database file with any special-magical tool and make it forget about the 100M portion, but this seems highly unlikely to work.


    small thinking, you can try at least. Make a new DB with 2 parts, one of 20GB, one of 100MB.

    Then rename that second one (100MB) to stay in place of deleted corrupted part of first DB.

    Even if that works-out, I think you'll have some data-loss and maybe other problems. You can try at least, I say.

    And Do not do that on your active DB. Make a copy and than test it...
  • Captain_DX4Captain_DX4 Member Posts: 230
    That is an interesting idea Phenno! I'd be interested to hear if it works.
    Kristopher Webb
    Microsoft Dynamics NAV Developer
Sign In or Register to comment.