Ask the Community
Groups
Failed to create integrity table 'msdb.dbo.UNITRENDS_<dbName>_BACKUPS_STATUS', and will not be able validate sql checkpoint for differential and transactional backups for current backup group. - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Microsoft SQL Server databases - Full backup is sucessful, but differential and transaction log backups fail</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h3 data-id="purpose">Purpose</h3> <p>Why are my Microsoft SQL Server Differential and Transaction backups failing?</p> <h3 data-id="description">Description</h3> Error message in failed differential or transaction log backup: <p>The integrity backup table for database '<dbName>', instance 'local' and validate differential or transactional log backup doesn't exist: Please contact the Database Administrator to ensure that CREATE TABLE permissions have been granted on database 'msdb' for the 'Unitrends' agent service account</p> <p>Message in the successful full backup that was prior:</p> <p>Failed to create integrity table 'msdb.dbo.UNITRENDS_<dbName>_BACKUPS_STATUS', and will not be able validate sql checkpoint for differential and transactional backups for current backup group.</p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p></p> <p>Add the sysadm role for the user the "BP Agent" service runs as, which is NT Authority\SYSTEM by default.</p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>Unitrends BP Agent runs as the Local System account by default. The user this account runs as does not have permissions to perform the necessary tasks.</p> </article> </main>