SA0099 : The Database is using Full Recovery Model, but its last transaction log backup is too old
The topic describes the SA0099 analysis rule.
The Database is using Full Recovery Model, but its last transaction log backup is too old
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.
The rule has a ContextOnly scope and is applied only on current server and database schema.
Number of days the after which the transaction log backup are considered outdated.
The rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.
Maintenance Rules, Bugs