To start, I am a database novice. I thank you for any help in advance.
I have a solarwinds SQL windows 2017 database in full recovery mode in an availability group. The database is roughly 2GB.
Yesterday, I went through the process of shrinking my log file that had continuously grown to ~120gb.
To prevent this issue in the future I:
- Configured the log file for an auto growth of 1gb and max size of 2gb (based on some solarwinds recommendations I had found)
- Scheduled regular Transnational log backups every 30sec (again based on some recommendations I had found)
... well, i accidentally configured the log backups to be every 30 minutes in error and i believe that is what then allowed the log file to fill to it's maximum size?
I am now receiving the error "The transaction log for database 'SolarWindsOrion' is full due to 'XTP_CHECKPOINT'"
I am unable to shrink the log file and I am also unable to update the log file to a bigger size (get the same error message)
I am wondering what the best course of action is and if there is anything else i need to do to prevent this issue in the future once resolved.