Delete change log entries

There is a page called Delete Change Log Entries... for pre-BC Versions. You can access it by searching for it in the search bar.

For BC, open Change log entries and under Actions tab, there is an action called Delete Entries

This will open a page where you can filter entries by Date and Time and/or Table No.. Once you click ok, the filtered entries will be deleted

Hi @gmsfzllc
You cannot delete throw SQL Logs, but you can delete throw T-SQL but your transaction log would increase until truck the log after next full backup.
That part cannot be skipped, unless you're willing to destroy your backups

gmsfzllc wrote: »

Thanks for your suggestion,

But I have lots of record in log entries. How can delete all record so that My Database size could not be increased.

Can I delete through SQL Logs.

Regards,

Yes, it takes time. But its the safest method. You can set the date in the date filter provided when you open the Delete Change Log Entries.. Page. It is advisable to not delete change log entries up-to past 1-3 months.

And as @sorenhinrup mentioned, if you log on too much entries, taking a look at the change log setup and unchecking the records which you dont want to log might reduce the change log entry lines in the future.