The PIA tool flags on a check named
SQL Server database recovery model. It indicates that your primary ePO database in SQL Server isn't using the simple recovery model.
If you use anything other than simple logging, it throws off the PIA tool's ability to anticipate the space needed on SQL Server for log file growth. The other recovery models require much more space in the LDF file. We recommend that you set the ePO database to a simple recovery model, unless you have a specific use case to use one of the other recovery models.
We're aware of two known exceptions where the primary ePO database must
not be set to use the simple recovery model:
- When you're using Database Mirroring
- Always On Availability Groups
The above two SQL configurations don't work with ePO in the simple recovery mode. In these scenarios, you can ignore the warning and confirm that you have sufficient free space to grow the logs. To learn more about these features, see the related articles below:
If you don't have a use case that requires the primary ePO database to use a recovery model other than simple, then implement the solution below.