alexlow
27th May 2007, 08:39
Hello,

I need some advice on backup of erp ln system, just wondering how everyone else do it.

our system is erp ln6.1 on win2k3 , sql 2005 .

By dump? just backup at file level?

:confused:

Regards,
Alex

sukesh75
27th May 2007, 08:56
Both the sequential dump and SQL backup should be considered when chalking out your backup plan. SQL backup is fast and has less of a drag on the system resources and can be taken hot and cold compared to the baan sequential dump. Depending on how your business is setup, whether its a 24/7 operation or something else, you would have to decide on when to run what...

sk

alexlow
27th May 2007, 09:13
sequential dump require the solutions to be same during restore and dump take quite long time to create. backing up the sql db will be will doing the same job right?

do you know which files or folders that must be backup to restore the applic?

thanks

sukesh75
27th May 2007, 09:59
There are different ways to use the backups to restore your app.
SQL backups are faster and so can be taken at a regular intervals and it helps in scenarios wherein the database gets corrupted.

As far as sequential dumps are concerned, its best usefull when you are trying to upgrade your server or in some cases restore a mighty crash that makes it necessary to install everything all over again. This is my way of seeing it. There could be others with a different turn to this.

Yes you need to have the same solution at the time of backing up and restoring. Along with it you could backup 000 (tools) company which will help in reducing recovery time. You could save the users/authorizations etc using ttcon61export tool and you could export your customized objects (form, reports) of all packages using ttiex1280m000 session.

Finally, you could get in touch with baan support on the /BSE folders that needs to be backed up which could aid the recovery process and cut the recovery time considerably...

sk

sudhir
24th September 2007, 09:56
is it important to take sequential dump daily.

sukesh75
24th September 2007, 10:19
That would depend on the size of the company you are backing up. If its in excess of 100 gb you could take a weekly sequential and a daily incremental. The above is also applicable if you are a 24/7 co and you cant accomodate offline time for your baan co..

sk