Other concurrent activities have reused the available space

nvg

Hi all,

I am in a big mess now. While I was compiling 2 of my customer databases, the power tripped and the databases got corrupted. When I am trying to log into these databases, I am getting long error messages:

Error on Database 1:
"Other concurrent activities have reused the available space that contained the snapshot of data"

It is asking me to expand the DB or delete unwanted data, blah blah..

But I cannot even login, how can I expand the database?

Error on Database 2:
"There is a corrupted area in the database. This type of error occurs if the database file is changed by another program or if the device driver does not function correctly"

Again, it is suggesting me to take a backup of the DB and restore that back again into a new DB. But when I cannot even login to the DB, how am I supposed to take a backup?

Can any one help? I even tried the HOTCOPY command but when it starts the backup, it aborts showing the same error messages which I get when I login.

Now 2 databases of mine are corrupted. Please help and suggest some remedy.

Thanks,
NVG

kriki

Try to open the DB directly with the client (so without server) in read-only mode (parameter : dbreadonly=Yes).
I hope that you can enter the DB and make a backup.

The only other thing I can think of is porting the DB to Microsoft and let them fix it. But this costs time and money.

nvg

Worst Luck.....

Cannot open the DB as readonly. Same error.

Any other suggestions?

Thanks for the reply.

NVG

kriki

I don't have any other ideas. Maybe someone else has a solution.

Shenpen

Microsoft has a tool called C/DART that can heal corrupted databases. Unfortunately they are not willing to give it out. I suggest to contact them.