Click or drag to resize

SA0141 : Database is using Simple Recovery Model

The topic describes the SA0141 analysis rule.

Message

Database is using Simple Recovery Model

Description

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.

Scope

The rule has a ContextOnly scope and is applied only on current server and database schema.

Parameters

Rule has no parameters.

Remarks

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Categories

Maintenance Rules

Additional Information
See Also

Other Resources