Vidéos d'aide de Screencast

Incremental failed

Created: 21 Fév. 2013 • Updated: 02 Mars 2013 | 3 comments
Ce problème a été résolu. Voir la solution.

I tried to backup to disk, the full backup is ok but when it tried to do incremental, it failed. Could someone tell me what does it mean and how to resolve.

Here the error is:

Backup Data Base-Incremental -- The job failed with the following error: The Backup Exec SQL Agent was not used to create the last full, differential, or log backup of this database. You must use the SQL Agent to run a full backup before you can run a differential backup or transaction log backup.

Regards,

Tho.

Commentaires CommentairesAccéder au dernier commentaire

l'image des Tho Phan

I found some solutions in other posts. I will try to follow those and if the problem still I will go back to the post.

Thank you every one.

Tho.

l'image des Tho Phan

Hi,

I found that our data base server is using SQL Server Agent to do backup. We don't use the 3rd party software. Does SQL Server Agent wil cause incremental failed like other 3rd agent?

Regard,

Tho.

l'image des VJware

Yes, as the SQL Server Agent (runs native SQL backups, maintenance plans etc) resets the LSN & will cause the incremental of Backup Exec to fail.

SOLUTION