I'm a stupid man - Erase a database part

gunther

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:)

DenSter

I hope you made a backup because I don't think you can recover that.

Captain_DX4

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.

Phenno

Captain DX4 wrote:

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_DX4

That is an interesting idea Phenno! I'd be interested to hear if it works.