Jump to content

Log retention


sysadmin-z

Recommended Posts

I have been using Passwordstate for around 8 months now. It is heavily ingrained into my Sys Ops processes and sees regular daily use. I discovered that the logs are at an undesired size due to the daily usage, particularily the passwordstate logs for SQL Server. I am not a SQL Server admin and am not sure if there is a way to have old SQL logs either archived or purged.

 

Is there a way to completely purge old logs and is there an option to due automatic purging at a set time?

 

Thanks.

 

Edit:

 

Upon further research I found out that the issue was caused by a growing transaction log. I set the recovery mode for the Passwordstate database to simple which will truncate the transaction log once a transaction has completed. This is acceptable due to limited data change and regular database backups.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...