SQL 2005 on Windows 2008, 2008R2, or Windows 7 differential failure contain error: a current database backup does not exist


Resolve issues with SQL 2005 differential backups.


Backup report or application schedule report message as follows:
----- Error Messages ----- 
Cannot perform a differential backup for database namedb, because a
current database backup does not exist. Perform a full database backup by
reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
BACKUP DATABASE is terminating abnormally.
----- End Error Messages -----


 Update SQL Server 2005 with Service Pack 3, click the link below and download the files most appropriate for you.
Download SQL Server 2005 SP3


Operation may break the differential backup chain of a SQL Server database and
may invalidate the differential backups when you perform a snapshot backup of
the database http://support.microsoft.com/kb/903643
http://support.microsoft.com/kb/921106 You receive an error message when you
try to create a differential database backup in SQL Server 2005


For more detailed information on backup failures and performance issues see Unitrends KB 5062 - Backup Failures and Performance Issues

Have more questions?

Contact us

Was this article helpful?
0 out of 0 found this helpful

Provide feedback for the Documentation team!

Browse this section