Skip to main content

Checkup Documentation

Last Transaction Log Backup (SQL)

critical system-sqlserver-last-backup-log

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.