• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

Restarting Sybase SQL Anywhere Database

When restarting the database (Customer.db) an error occurs. It looks for the (Customer.log) file (which was deleted).  How can I restart the database without the log file?  Can I create a generic log file and place it on the server? Is there some command line switch I can use to restart the database a different way? Looking for a step by step checklist to restart the database.
1 Solution
If you delete the log, you can force the engine to start without a log using the -f parameter to dbeng50.  ie,

dbeng50 -f customer.db

This will start customer.db and allow a new log to be created when needed.  If this database is part of a replication setup, this will break replication.
rickwinterkornAuthor Commented:
Thanks Tom, worked well!
>dbeng50 -f customer.db

If it does not work try undocumented key
dbeng50 -o ...
remove transaction log
     dblog -n customer.db
and start the database.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now