SYMPTOM:
When attempting to upgrade the metadata in Microsoft SQL Server to Strategy 9 via Configuration Wizard, the operation hangs with the following error message:
Sample Code/Error
Odbc error. Odbc operation attempted: SQLExecDirect. The log file for database 'xxxx' is full. Back up the transaction log for the database to free up some log space.
The statement has been terminated.
Even when increasing the size of the transaction log, the operation still fails.
CAUSE:
Transaction log was recording very detailed information.
ACTION:
Set the Recovery model of the transaction log to simple.
From SQL Server 2000 onwards Microsoft supports three different types of recovery models. They are Simple Recovery Model, Bulk Logged Recovery Model and Full Recovery Model. It is possible to have different recovery models configured for different database on a single instance of SQL Server.
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
KB33080
