We are having an issue with a database that a customer has provided to us, we are getting the following error when we try to open the tables using the dbsys430.exe tool "DBISAM Engine Error # 12036 the table of backup file <filename> is not valid"

The situation is that they recently had a hard drive crash and they used a data recovery group to restore what they could, during this process it appears that some of the few database files that we can access have rows with the following text “????Data Recovery Labs?????” which to us indicates that something other than our software wrote to the files during the transfer process

tried running the verify and repair tool in dbsys but to no avail

Is there any was that we can restore access to the files

Matthew


I don't know of anything. The only sane thing to do at this point is email or phone Tim directly

Roy Lambert [Team Elevate]

Hi Matthew,

Do the tables having missing .blb files by any chance?

Chris Holland [Team Elevate]

On 10/05/2012 07:56, Matthew wrote:
> We are having an issue with a database that a customer has provided to us, we are getting the following error when we try to open the tables using the dbsys430.exe tool "DBISAM Engine Error # 12036 the table of backup file<filename>  is not valid"
>
> The situation is that they recently had a hard drive crash and they used a data recovery group to restore what they could, during this process it appears that some of the few database files that we can access have rows with the following text “????Data Recovery Labs?????” which to us indicates that something other than our software wrote to the files during the transfer process
>
> tried running the verify and repair tool in dbsys but to no avail
>
> Is there any was that we can restore access to the files
>

Hi Chris

some do most don't, if they are gone is there any way to recover them


Chris Holland wrote:

Hi Matthew,

Do the tables having missing .blb files by any chance?

Chris Holland [Team Elevate]

On 10/05/2012 07:56, Matthew wrote:
> We are having an issue with a database that a customer has provided to us, we are getting the following error when we try to open the tables using the dbsys430.exe tool "DBISAM Engine Error # 12036 the table of backup file<filename>  is not valid"
>
> The situation is that they recently had a hard drive crash and they used a data recovery group to restore what they could, during this process it appears that some of the few database files that we can access have rows with the following text “????Data Recovery Labs?????” which to us indicates that something other than our software wrote to the files during the transfer process
>
> tried running the verify and repair tool in dbsys but to no avail
>
> Is there any was that we can restore access to the files
>

Hi Matthew,

I don't know of any way to recover the information in the missing .blb
files, but I believe you can recreate a blank copy of the missing .blb
files by restructuring the table.

Chris Holland [Team Elevate]

On 14/05/2012 06:09, Matthew wrote:
> Hi Chris
>
> some do most don't, if they are gone is there any way to recover them
>
>
> Chris Holland wrote:
>
> Hi Matthew,
>
> Do the tables having missing .blb files by any chance?
>
> Chris Holland [Team Elevate]
>
> On 10/05/2012 07:56, Matthew wrote:
>> We are having an issue with a database that a customer has provided to us, we are getting the following error when we try to open the tables using the dbsys430.exe tool "DBISAM Engine Error # 12036 the table of backup file<filename>   is not valid"
>>
>> The situation is that they recently had a hard drive crash and they used a data recovery group to restore what they could, during this process it appears that some of the few database files that we can access have rows with the following text “????Data Recovery Labs?????” which to us indicates that something other than our software wrote to the files during the transfer process
>>
>> tried running the verify and repair tool in dbsys but to no avail
>>
>> Is there any was that we can restore access to the files
>>

Hi Chris,

How would i go about reconstructing the table, we are using dbisam 4 tables, and the database tool dbsys430.exe

Regards,


Chris Holland wrote:

Hi Matthew,

I don't know of any way to recover the information in the missing .blb
files, but I believe you can recreate a blank copy of the missing .blb
files by restructuring the table.

Chris Holland [Team Elevate]

On 14/05/2012 06:09, Matthew wrote:
> Hi Chris
>
> some do most don't, if they are gone is there any way to recover them
>
>
> Chris Holland wrote:
>
> Hi Matthew,
>
> Do the tables having missing .blb files by any chance?
>
> Chris Holland [Team Elevate]
>
> On 10/05/2012 07:56, Matthew wrote:
>> We are having an issue with a database that a customer has provided to us, we are getting the following error when we try to open the tables using the dbsys430.exe tool "DBISAM Engine Error # 12036 the table of backup file<filename>   is not valid"
>>
>> The situation is that they recently had a hard drive crash and they used a data recovery group to restore what they could, during this process it appears that some of the few database files that we can access have rows with the following text “????Data Recovery Labs?????” which to us indicates that something other than our software wrote to the files during the transfer process
>>
>> tried running the verify and repair tool in dbsys but to no avail
>>
>> Is there any was that we can restore access to the files
>>

Hi Matthew,

In DbSys select the Menu option:

Utilities -> Alter Table

From the shown table structure if you add a blob field at the bottom it
will recreate the missing .blb file.

Chris Holland [Team Elevate]

On 15/05/2012 01:47, Matthew wrote:
> Hi Chris,
>
> How would i go about reconstructing the table, we are using dbisam 4 tables, and the database tool dbsys430.exe
>
> Regards,
>
>
> Chris Holland wrote:
>
> Hi Matthew,
>
> I don't know of any way to recover the information in the missing .blb
> files, but I believe you can recreate a blank copy of the missing .blb
> files by restructuring the table.
>
> Chris Holland [Team Elevate]
>
> On 14/05/2012 06:09, Matthew wrote:
>> Hi Chris
>>
>> some do most don't, if they are gone is there any way to recover them
>>
>>
>> Chris Holland wrote:
>>
>> Hi Matthew,
>>
>> Do the tables having missing .blb files by any chance?
>>
>> Chris Holland [Team Elevate]
>>
>> On 10/05/2012 07:56, Matthew wrote:
>>> We are having an issue with a database that a customer has provided to us, we are getting the following error when we try to open the tables using the dbsys430.exe tool "DBISAM Engine Error # 12036 the table of backup file<filename>    is not valid"
>>>
>>> The situation is that they recently had a hard drive crash and they used a data recovery group to restore what they could, during this process it appears that some of the few database files that we can access have rows with the following text “????Data Recovery Labs?????” which to us indicates that something other than our software wrote to the files during the transfer process
>>>
>>> tried running the verify and repair tool in dbsys but to no avail
>>>
>>> Is there any was that we can restore access to the files
>>>

Hello Chris

Nope it isn't even letting me use the Alter Table option in dbsys, i tried adding some of the dat files into an empty dataset and running the repair, in doing this it allowed access for some of the files but the data was a mess, missing records and corrupted data entries

I have come to the conclusion that the data is to far gone, we have an old backup and are in the process of rebuilding the data

Thanks for your assistance with this


Chris Holland wrote:

Hi Matthew,

In DbSys select the Menu option:

Utilities -> Alter Table

From the shown table structure if you add a blob field at the bottom it
will recreate the missing .blb file.

Chris Holland [Team Elevate]

On 15/05/2012 01:47, Matthew wrote:
> Hi Chris,
>
> How would i go about reconstructing the table, we are using dbisam 4 tables, and the database tool dbsys430.exe
>
> Regards,
>
>
> Chris Holland wrote:
>
> Hi Matthew,
>
> I don't know of any way to recover the information in the missing .blb
> files, but I believe you can recreate a blank copy of the missing .blb
> files by restructuring the table.
>
> Chris Holland [Team Elevate]
>
> On 14/05/2012 06:09, Matthew wrote:
>> Hi Chris
>>
>> some do most don't, if they are gone is there any way to recover them
>>
>>
>> Chris Holland wrote:
>>
>> Hi Matthew,
>>
>> Do the tables having missing .blb files by any chance?
>>
>> Chris Holland [Team Elevate]
>>
>> On 10/05/2012 07:56, Matthew wrote:
>>> We are having an issue with a database that a customer has provided to us, we are getting the following error when we try to open the tables using the dbsys430.exe tool "DBISAM Engine Error # 12036 the table of backup file<filename>    is not valid"
>>>
>>> The situation is that they recently had a hard drive crash and they used a data recovery group to restore what they could, during this process it appears that some of the few database files that we can access have rows with the following text “????Data Recovery Labs?????” which to us indicates that something other than our software wrote to the files during the transfer process
>>>
>>> tried running the verify and repair tool in dbsys but to no avail
>>>
>>> Is there any was that we can restore access to the files
>>>