GGM-Admin
19th February 2008, 08:01
Hi all

I have the following problem during installation from BaanIVc4 on W2K3 with MSSQL database.

The database is about 32 GB and the transactionlog is 4 GB. During importing tables I get the error 2105 in Baan ( DB error 1105) transactionlog is full.

I have no possiblity to backup the transaction log (wh is it not possible??) and the option dump database with no_log is also not working

Any ideas?? What can I do to resolve it??

Regards

Markus

mig28mx
19th February 2008, 17:46
Hello,
I´m not MSSQL experienced, but in Informix, also this happens.
Perhaps the same solution apply for you.
We had addressed the transaction log to a series of files. When this files are full, the database can´t continue due to log full. So, we re-addressed the transaction log files to a tape device and, in operation, this tape are preserved until next level 0 backup.

Addicionally, when I upload a great amount of data, I usually address the transaction log to null device.

Hope this helps.

GGM-Admin
21st February 2008, 16:45
Hi
thanks for your answer... but that doesn't help. I have no possiblity to backup the logs to anywhere. Its "grey" in MSQL Enterprice Manager.

Regards

Markus