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.


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

Additional Information
See Also

Other Resources