SA0141 : Database is using Simple Recovery Model
The topic describes the SA0141 analysis rule.
Database is using Simple Recovery Model
The rule checks the current database for using Simple Recovery Model.
Using the Simple Recovery Model, prevents point-in-time recovery which will increase the amount of data loss in the event of a disaster recovery.
It is recommended that Full Recovery Model is used on all production databases and that frequent transaction log backups are taken. This way it will be ensured a recoverability with minimal loss of data.
Change the database recovery model to Full Recovery Model.
ALTER DATABASE database_name SET RECOVERY FULL
The rule has a ContextOnly scope and is applied only on current server and database schema.
Rule has no parameters.
The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.
Maintenance Rules, Bugs