SQL Server Differential Backup Completes with Warning: SQL Server Error 3035/42000
説明
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.
原因
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.
対策
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).
