Ask the Community
Groups
SQL Database backup fails with warning "Failed to create table" - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>SQL Database backup fails with warning "Failed to create table"</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h3 data-id="applies-to">Applies To</h3> <p>SQL Agent backups for database with very long names.</p> <p>SQL Server 2008, 2008R2, 2005 and 2000</p> <h3 data-id="symptoms-description">Symptoms / Description</h3> <p>Databases with names over 103 characters may fail to backup with the following messages:</p> <blockquote class="blockquote"> <p>FATAL: No backup data received from client.</p> <p>Exit Code......: 2</p> <p>Exit Status....: Misc error</p> <p>Failed to create table '’, and will not be able validate sql checkpoint for differential and transactional backups for current backup group.</p> </blockquote> <p> </p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p></p> <p>To protect database with very long names using the Unitrends VSS SQL Agent</p> <ul><li>Rename the databases to less than 102 characters</li></ul> Refer to you application directions for renaming databases (references for SharePoint are provided under Third-Party Sources). Alternatively, the Unitrends Windows agent can protect the files created using SQL Backup with the Recovery Appliance’s retention, backup archiving and vaulting. <h3 data-id="third-party-sources">Third-Party Sources</h3> <p>Renaming Content Databases <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fblogs.technet.com%2Fb%2Fwbaer%2Farchive%2F2008%2F06%2F16%2Frenaming-content-databases.aspx">http://blogs.technet.com/b/wbaer/archive/2008/06/16/renaming-content-databases.aspx</a></p> <p>Renaming crazy SharePoint Database Names <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fblogs.technet.com%2Fb%2Fseanearp%2Farchive%2F2009%2F03%2F14%2Frenaming-crazy-sharepoint-database-names.aspx">http://blogs.technet.com/b/seanearp/archive/2009/03/14/renaming-crazy-sharepoint-database-names.aspx</a></p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>The SQL Agent cannot create checkpoint tracking tables for database with names over 102 characters (Bug 13079). While not common, long database names are typical of applications that automatically generate databases using GUID’s (such as SharePoint).</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>