i have delete log file of sql anywhere in BO 4 without backup and now BO4 don't start

[former_member594340]

i have delete log file of sql anywhere in BO 4 without backup because the space on disk was 0 byte and now BO4 don't start, this is a test enviroment and i don't have any backup.

is there a way to solve?

[denis_konovalov]

I have fixed your tag as your question has nothing to do with BI platform.

[former_member182948 · Accepted solution]

If you delete the transaction log, you need to force the database to start.

From the cmdline start the database with recovery option "-f" switch.
i.e : dbeng16 <database.db> -f

If the recovery has completed, the SQL Anywhere engine will shutdown automatically.
After that, you will be able to start the database.

For details, please see the below.

-f database server recovery option

[chris_keating]

The -f option is a force start intended as a last resort i.e., the transaction log is no longer available or damaged. The transaction log may have data that is not in the database. If you force start the database, that data will be lost. You should never delete the active transaction log. You would be better to move that log to another location and then address the disk space issues. Please note that an SQL Anywhere event can be implemented to monitor disk space so that it can be addressed if space is low.

You likely also need to start managing the size of the transaction log. You can do so during the backup of the database (which you should be doing for disaster recovery). .

[former_member594340]

thanks your solution has solved my problem