Logging MSSQL purge old entries

Question

Hello @All,

I use external logging in MSSQL and now we have 29GB database size and i want to cleanup the logs older that 6 month.
The biggest tables are:

a) Operations
b) Operations2OperationTypes

What can I do to cleanup the entries in the db?

Thanks ;)
Arne Tiedemann

Answer 1

Hello Arne,

To cleanup events older than 6 months, execute the following command on your SQL Server:

DELETE FROM [AdaxesLogDB].[dbo].[Operations] WHERE [OperationStartTime] < DATEADD(month, -6, GETDATE())

where AdaxesLogDB is the name of the logging database.