Outdated backup
Applies to:
SQL Server
This rule checks that a database has recent backups. Scheduling regular backups is important for protecting your databases against data loss from many different failures. The appropriate frequency for backing up data depends on the recovery model of the database, on business requirements about potential data loss, and on how frequently the database is updated. In a frequently updated database, the work-loss exposure increases fairly quickly between backups.
Best practices recommendations
We recommend that you perform backups frequently enough to protect databases against data loss.
The simple recovery model and full recovery model both require data backups. For either recovery model, you can supplement your full backups with differential backups to efficiently reduce the risk of data loss.
For a database that uses the full recovery model, we recommend that you take frequent log backups. For a production database that contains important data, log backups would typically be taken every one to fifteen minutes.
Note
The recommended method for scheduling backups is a database maintenance plan.
For more information
Back up and restore: System databases (SQL Server)
Create a Differential Database Backup (SQL Server)
Transaction log backups (SQL Server)
Related content
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin