Ask the Community
Groups
SQL 2005 on Windows 2008, 2008R2, or Windows 7 differential failure contain error: a current database backup does not exist - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Resolve issues with SQL 2005 differential backups.</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <p>Backup report or application schedule report message as follows:<br> ----- Error Messages ----- <br> Cannot perform a differential backup for database namedb, because a<br> current database backup does not exist. Perform a full database backup by<br> reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.<br> BACKUP DATABASE is terminating abnormally.<br> ----- End Error Messages -----</p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p></p> <p> Update SQL Server 2005 with Service Pack 3, click the link below and download the files most appropriate for you.<br> * <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D17667">Download SQL Server 2005 SP3</a></p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>Operation may break the differential backup chain of a SQL Server database and<br> may invalidate the differential backups when you perform a snapshot backup of<br> the database <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F903643">http://support.microsoft.com/kb/903643</a><br> And <br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F921106">http://support.microsoft.com/kb/921106</a> You receive an error message when you<br> try to create a differential database backup in SQL Server 2005</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>