Skip to main content

Checkup Documentation

Last Full Database Backup (SQL)

critical system-sqlserver-last-backup-full

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.