>Hello SQL users,
>Who can help me with the following,
>We are using sql 6.5 for an imaging program.
>The problem is that when we make a dump of the database, the transaction
>is not automatically cleared.
>As a result, the users are not able to log in because the transaction log
>fills up.Please inform me when you have a solution to this problem.Thank
1. Dump the log to some real device. You might do this periodically between
2. Dump the log with no_log or truncate_only. You would do this when you
dump the database.
3. Set the database for trunc. log on chkpt. This means you can only
recover to your last database dump.
You must determine how important the recovery of your data is to decide
which is right for you.
e-mail: Remove nospam. from reply address.