Simple recovery mode in MSSQL

question
1

Hi,

I’m using Hangifre.SqlServer in production. My site was down due to 'The transaction log for database ‘xxx.Hangfire’ is full due to ‘LOG_BACKUP’.

I wonder if
a) setting the recovery mode to SIMPLE rather than FULL
b) limiting the transaction log size

will help me overcome this issue safely. I’ve got only a few jobs per month.

2

Did you find a solution @kozziification?

My Hangfire-database is using recovery mode SIMPLE, yet, the log file grows rapidly.