Last full database backup (SQL)
severity-critical
system-sqlserver-last-backup-full
Summary
Our Constant Care for Kentico Team suggest running full database backups every 24 hours (ideally off hours). However, based on your specific site and environment, these settings may vary. We suggest working with your Xperience Gold Partner and/or your IT Team to figure out the best settings based on your site's activity and how often your site's data changes (think about internal users, external users, automated processes, integration points, etc).
Check Logic
Constant Care for Kentico will ensure the hours since the last full database backup is no more than 24 (default)
You can manage your settings for this checkup in the Constant Care for Kentico admin settings.
Resolution
To review your latest backup, check out the backup properties of your database in your SQL Manager.
If you are interested in running a SQL script to review all your databases, you can run this:
SELECT
[database_name]
, HoursSinceLastBackup = DATEDIFF(HOUR, MAX(backup_finish_date), GETDATE())
, LastBackupDateTime = MAX(backup_finish_date)
FROM msdb.dbo.backupset
WHERE [type] = 'D' -- Database (Full Backup)
GROUP BY [database_name]
ORDER BY [database_name]
If you do not like what you see, you may need to work with your IT Team to create or update your SQL Maintenance plan.
Not sure what to do?
If you are ever unsure about making changes to your site, we encourage you to reach out to your
Kentico Xperience Gold Partner. If you do not have a partner,
then feel free
contact the Constant Care For Kentico team to get connected
with an expert.