Last transaction log backup (SQL)
severity-critical
system-sqlserver-last-backup-log
Summary
Our Constant Care for Kentico Team suggest running Transaction Log Database Backups every 15 minutes. 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, and how much data you are willing to lose in a disaster recovery event.
As always, if the default setting is too aggressive for you, you can always set it to whatever you want.
Note: Even though we suggest Transaction Log Backups to be done at least every 15 minutes, the check's default value is 20 minutes. This is because it can take a little time to run the actual backup. This allows a little buffer.
Check Logic
Constant Care for Kentico will ensure the minutes since the last transaction log database backup is no more than 20 (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]
, [type]
, MinutesSinceLastBackup = DATEDIFF(MINUTE, MAX(backup_finish_date), GETDATE())
, LastBackupDateTime = MAX(backup_finish_date)
FROM msdb.dbo.backupset
WHERE [type] IN ('D', 'L') -- D: Database (Full Backup), L: Log (Transaction Log)
GROUP BY [database_name], [type]
ORDER BY [database_name] DESC, MAX(backup_finish_date) DESC
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.