Return
-
Title
SQL Server Differential Backup Completes with Warning: SQL Server Error 3035/42000 -
Description
SQL Server plugin differential backup job completes with warning. One or more databases fail to be backed with SQL Server error 3035 or 42000: Cannot perform a differential backup for database "%ls", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
Full backup jobs complete OK. -
Cause
If another process takes a snapshot of the SQL Server, the backup chain breaks. Consequently, a differential backup that follows the previous full or differential backup taken won't be possible. -
Resolution
Ensure that no other backup application is taking snapshots using the SQL Server writer. Starting a new backup chain will break the one initiated by NetVault. If the other process in unavoidable, reconsider the backup strategy (e.g. drop the differential jobs and run full backups more frequently).