Click or drag to resize

SA0099 : The Database is using Full Recovery Model, but its last transaction log backup is too old

The topic describes the SA0099 analysis rule.

Message

The Database is using Full Recovery Model, but its last transaction log backup is too old

Description

The rule reports when the database uses Full Recovery Model and has a too old or none transaction log backup.

If the transaction log is not backed up regularly, the log files can become very large and point-in-time recovery becomes impossible. For such databases, it is recommended to have periodic transaction log backups to checkpoint the log and remove inactive transactions.

Scope

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

Parameters
NameDescriptionDefault Value
ExpirationDays

Number of days the after which the transaction log backup are considered outdated.

1

Remarks

The rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.

Categories

Maintenance Rules

Additional Information
See Also

Other Resources