Delete Change Log Entries

amphysvena

Hi,
We're planning to delete the change log entries data, & we're now using report 510 - Change Log - Delete
The problem is, every time we run the report, it will than show error message after a period of time. The error message is:

The following ODBC error occurred:
Error: [Miscrosoft][ODBC SQL Server Driver]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.
State ID: HY000

Even if we only delete 1 day data, it still shows the error.
How to fix this?
Can I just delete it manually? Open the table, filter then delete the data?
Thx

Tomas

Yes, you can delete them from the Change Log Entry table.

amphysvena

Ok, I'll delete the data from table. Wonder if there is any side effect.
But, i'm still curious, why the error appear?
greatly thanks for the reply

bergoulle

amphysvena wrote:

Ok, I'll delete the data from table. Wonder if there is any side effect.
But, i'm still curious, why the error appear?
greatly thanks for the reply

May be the transaction log file.
You could be running out of space where the transaction log file is locate on your disk or
you might have a limitation size on this file.

amphysvena

I have limited access to the server. But I guess the drive C is out of space. So the error occurred. Anyway, I already delete the change log manually.
Thanks for all the replies.