Hello ,

We are 24 hour company. when we use create dump data and other user do transactions within the baan tables are on going. BaaN will give message on that's user "Error 107 (Record is locked) on whinh260939 (Max retries(10) cannot not continue...

Data on table whinh260939 very huge so when dumping data this table will lock it.

we are using windows 2000 advance server , database SQL 2000 , BaaN ERP sp11 porting set 7.1 d 03

I hope you understand what's I meaning

Thanks a lot .
Nopadon

When baan takes sequential dump , it always locks the table. Hence the table can only be read and not written.

But this is what is really required consistency requirement of backup. Even if hypothetically it were to allow backup while users are online and transactions occur , that backup is of no use because of online transactions and resulting inconsistency in the backup.

So in ur example u may schedule backups in weekend when people are not online . Ideal situation would be to have an extra DB instance in which data is updated (read backed up ) online .

Dear Hitesh

Could you elaborate on DB Instance and Readbacked up.

What are you doing at your end for taking sequential dump even when people are working in the system.


:confused:

Dear Vineetu,

Ours is not a 24X7 company . It's 12X6 company. So we schedule the backup at night when no users are working on the system.

Further we have a redundant server with Baan networked license with Baan logic server and DB instance installed in it. Through Baan net, the data are updated online in other server.

All databases have their own native replication methods and u can use it's native capabilities to such replication.

There is nothing 'ReadBackedup'. It just implied online updation in other server is online backing up.

Dear Hitesh,

Can you give me the setup required for the setup of Baan Logic server and db instance.

At present we have defined a job which executes at night for taking sequential backups. We store these backups in Cartridges.

We also have a Backup server as part of Disaster recovery plan. On weekly basis we are restoring the data on this backup server. For this first all the tables are deleted and then created and then tables are restoed from sequential dump. This server is also on network license.

I think it would be better if I could setup what you have done..i.e. Baan logic server and db instance. Can you give the details.

Is this an online backup or batch process. If it is online then it must be affecting the performance of the live server?

Thanks,
Vineet

:)

Vineet,

I will tell u our setup . But that may not be useful to u due to different os and database.

u search this forum like Disaster recovery (http://www.baanboard.com/baanboard/search.php?s=&action=showresults&searchid=230864&sortby=lastpost&sortorder=descending) . U'll find lot of useful information.

Here is our setup in brief from whatever i could recollect. I am not in front of my system.

1. Same porting set on both server.
2. Networked license
3. Maintain systems (other server) (ttaad0150m000)
4. Maintain remote users(ttaad2101m000) (ruser files created after convert
to runtime DD)
5. Database definition with a copy to separate server. (Convert to runtime
DD will create isamdef6.1)
6. Assign tables to database (tabledef6.1 created).

Please contact Baan support center for more detailed assistance.
Good luck.