Ask the Community
Groups
SQL transaction log backup fails Error: Unable to perform a Transaction Log backup of database: '**********', instance '*********' It appears that a continuous sequence of Transaction Log backups is not intact. - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>SQL transaction log backup fails</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h3 data-id="applies-to">Applies To</h3> <p>SQL Transaction log backup</p> <h3 data-id="symptoms-description">Symptoms / Description</h3> <p>SQL Full backups are successful, but transaction log backups fail;</p> <p>Windows Event ID 263 from source “Unitrends Agent” with summary (id 3340) session completes. Failed to send summary. Error returned 0xffffffff;</p> <p>The WBPS log on the client, c:/PCBP/Logs.dir, shows the following message:</p> <p>ERROR!!! Backup was taken outside of Unitrends SQL Agent, or agent can not validate sql checkpoints for differential and transactional backups.<br><br> </p> <pre class="code codeBlock" spellcheck="false" tabindex="0"> Excerpt from c:\pcbp\logs.dir\WBPS_01.log_j145628.err S Q L G R O U P B A C K U P I N F O Instance: \test_SQL DataBase: test_db _____________________________________________________________ Start date | Status | Type |VSS _____________________________________________________________ 2019-04-05 13:01:53.000|COMPLETE |FULL |Yes _____________________________________________________________ - DPU :Unitrends_VSS - Client :test_SQL ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ _____________________________________________________________ 2019-04-05 14:00:01.000|UNKNOWN |LOG | No _____________________________________________________________ - ERROR :Backup was taken outside of Unitrends SQL Agent - Device <img class="emoji" src="https://kaseya.vanillacommunities.com/resources/emoji/lol.png" title=":D" alt=":D" height="20" loading="lazy"></img>:\backups\SQL_dumps\test_db_backup_2019_04_00_000001_1468476.trn</pre> <br>Error above lists native log truncation (may also see full dump of SQL DB instead) <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p></p> <p>Disable maintenance plans, and re-run a new SQL full of the database in question, <span style="font-size: small;"><b>or</b></span></p> <p>Switch <b>both</b> the maintenance plans and the DPU backups to do SQL Fulls <b>only.</b></p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>A maintenance plan or another backup product did a backup of this SQL database in between our last full backup and this one.</p> <h2 data-id="notes"><strong>NOTES</strong></h2> <p>For more detailed information on backup failures and performance issues see <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Funitrends-support.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360013174757">Unitrends KB 5062 - Backup Failures and Performance Issues</a>.</p> </article> </main>