Hi,
Our Hard Disk of the BaaN Server crashed and we were unable to recover the data from it. And hence, no backup of sequential dumps and $BSE folder could be recovered

We had only SQL Data backup(".bak" file). Now we had installed the BaaN server afresh. We have tried to restore the data (All tables except TOOLS tables) using SQL DTS import/export wizard in SQL Server 2000.
All data have been copied except "parameters table". Error - "Duplicate index value" is displayed every time we try to restore/export any parameter table.

Please help.

Thanks in Advance.

This means u did not have SQL backup . U have only export dump of each table.

If importing para tables say duplicate , then it already exists . Why import again . Check in SQL ent manager the data in para table .

Further if u are not importing any tools tables , then all customizations (form,report, program , sessions, label , tables , domain ) are not imported . And your create runtime dd (ttadv5210m000) will wipe out all customized domain/ table / sessions dictionaries. And form,report , programs etc will not be available for modification in future.

Hi Hitesh,
Thanks for your reponse. Actually we are having only SQL Server Database Back up file - ".bak" file. I just deleted the rows of parameters tables thro' GTM. Then export parameters tables from .bak file to newly created baandb tables using SQL DTS functionality. All tables exported successfully

Now next step is to export data of tools tables, so that the customization is also uploaded. But as you mentioned, i have already done CRDD for tools. Are there any selective tools tables which store customization? If not what is the other wayout?

Please help.

As u have the entire environment backup , there is no reason why u should not restore entire tools directory unless u have installed the same again and at a different service pack level .

Selectively it may be better to exclude the tables not to be restored rather than to select tables to be restored .

Actually guys here were having no info about the PVRC, Combination, Service pack level etc as their IT guys resigned and did not pass on info. I got to know only company numbers

I arbitrarily created pkg. combi, pVRC, and installed upto SP 23.
Is there any way to load tools tables to restore customizations?

U have / had the environment . First restore the same so that work can go on
from runtime.

Then U can study package combination / packge VRCs from packagefile defs . Create such packge comb/vrcs in actually . From the tools dump import/export records of customized VRC's only (No ready list of tables!) . And import the filtered records and then rebuild ttadv5210m000 .

In short there is no short cut to ur customization restore problem.

If there is not much customization , it is not worth . U may simply create the customization again.