Video Screencast Help

Incremental failed

Created: 21 Feb 2013 • Updated: 02 Mar 2013 | 3 comments
This issue has been solved. See 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.

Comments 3 CommentsJump to latest comment

Tho Phan's picture

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.

Tho Phan's picture

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.

Vivek Jain's picture

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