Managing Oversized Configuration Logging database.
Article ID: CTX215069
Updated On:
Description
This article is about using Powershell cmdlet to specify how long data is retained in the configuration logging database.
Instructions
For on-prem deployments,Powershell cmdlet, Remove-LogOperation does the required deletion.
This cmdlet targets high level operation logs for deletion. The associated low level operations logs are deleted as part of this operation via cascade deletion functionality present in the configuration logging database schema.
Example,
Remove-LogOperation -username "domain\userName" -password "password" -StartDateRange "2013-01-01 12:00:00" -EndDateRange "2013-01-31 12:00:00"
For CVAD service,
In the Set-LogSite cmdlet, the -LoggingDBPurgeDurationDays parameter specifies how many days data in the configuration logging database is retained before it is deleted automatically.
- By default, the value of this parameter is 0. A zero value means that data in the configuration logging database is never deleted automatically.
- When you set a non-zero value, the database is checked once every 120 minutes. Data older than the retention period is deleted.
Was this article helpful?
Yes
No
Powered by
