Two part questions: Journals and LOGs

If you don't want to delete you can get an archive tool from Retail realm that will remove them and keep them in a separate database you can access when you need to. Craig

Understood. We were looking for a solutions we ourselves can perform, maybe later on purchas a solution.

What about the LOGS?

"Craig" wrote:

Do you mean the transaction log in sql? The journal is kept in the journal table in the database. If your transaction log is so big you'd better go to your sql manager and backup the transaction log. This will dramatically reduce it's size.

Sorry about that; its the transaction log.

Backing up is done. How can we reduce the transaction log size?

"Jerry" wrote:

We hava a very peculiar situation.

We noticed that the LOG of the SO database increases fast, over 10gb and the database is less than that.

Also, researching cause of DB increase thru reading up RMS docs, that RMS saves an receipt image as a Journal and this can increase the database.

QUestions:

1. We don't want to delete the Journals, so how can we redirect the Journals to be saved to another drive or any suggestion for this type of problem?
2. Whats the best practice to maybe automate the LOG reduction or deleting the LOG database from SQL?

Thanx! Excellent!

I think this trully answer the LOG issue.

Question:

I see that setting the DB Recovery Mode 'Simple', automatically reduded the sizes. If we set to 'Simple', there's no more user intervention to clean uo on the LOG files?

And to what checkpoint value is it referring to? Is it modifyable por can we change the checkpoit value?

Thanx

"Jeff @ Check Po>