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.

How to fix

Change the database recovery model to Full Recovery Model.

SQL Syntax:

ALTER DATABASE database_name SET RECOVERY FULL

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.

Effort To Fix
1 hour per issue.
Categories

Maintenance Rules, Bugs

Additional Information
See Also

Other Resources