Differential backup of SQL database may report 'Cannot perform a differential backup for database DB_Name, because a current database backup does not exist"

Problem

 A differential backup of SQL database may report ' Cannot perform a differential backup for database "", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.'

Error Message

 
Backup job log shows:-
 
V-79-65323-3035 - Cannot perform a differential backup for database "<name>", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.

Cause

 

 This issue occurs when the internal status flag for a full database backup does not reset after creating a full database backup.

Solution

 
1. As per Microsoft article this is a SQL issue. Please refer to the article below for more information:

 

 
2. To resolve this issue download and install the hotfix mentioned in the article above.
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)