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

Thanks for letting us know.

 

If you ever need the ability to have point in time restores from transaction logs in the future, then SQL Server has maintenance jobs which can truncate and shrink the logs at backup time as well.

Regards

Click Studios

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...