Unable to access the link of success center

prashantsingh

Hi Team,

I am getting warning for Database recovery model check in Deployment health

The link for KB article needs login credential. Please look into this.

Your database recovery model is set to FULL. SolarWinds recommends that you use SIMPLE recovery model to ensure the best performance. Please check SolarWinds KB from the link provided above.

Related KB articles

• 1359

https://support.solarwinds.com/SuccessCenter/s/article/Database-recovery-model-Change-recovery-model-to-Simple

Thanks

Prashant

aLTeReGo

This should be a warning only and nothing to be concerned about if your SQL server is properly managed. The issue that occurs and the reason why this check exists at all is that it's far too common for users to deploy Orion in their production environment using the default 'Full' recovery model. What they don't realize is that a 'Full' recovery model writes data, not to the database, but to transaction log files. Only after a database backup has occurred, are those records committed to the database. This causes some customers to run out of space on their SQL server since some do not backup their Orion database often (or at all). This issue with running out of space due to transaction logs infinitely growing due to a lack of database backups does not occur when using a 'Simple' recovery model.

Now if you're backing up your Orion database regularly, then this is nothing to be concerned with. In fact 'Full Recovery' mode is actually required in instances where your Orion database needs to be made redundant using SQL AlwaysOn availability. So this check can be safely ignored once you've verified that it's not applicable to your environment.