07-15-2014 11:38 PM
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.
Am getting this error. I have seen many articles about this here. I need to know whether backup exec wil stop showing this only if the SQL's default backup is stopped totally? wont it work if the job are scheduled in a way that these backups doesn't coincide at the same time?
Please advice!
Solved! Go to Solution.
07-16-2014 12:26 AM
That's right. However, the default backup cannot be run on weekend after the Full backup by BE as the next incremental backup will not refer to the Full backup by BE, but it will refer to the most recent backup which was the default backup on the weekend.
The default backup (if needed) must be run AFTER all the incrementals and BEFORE the full. In your case, the default backup must be run on Thu after all incrementals and before Friday's full.
07-15-2014 11:47 PM
As you are running SQL default backup, it is affecting the LSN causing the incremental backups by BE to fail.
You can either disable the SQL default backups or setup the backups in such a manner that they do not conflict.
For egs.
Full SQL by BE
Incr SQL by BE
Incr SQL by BE
Once all incrementals are completed and prior to the full backup by BE, you can run the SQL default backup. This will not affect as the chain of Full + Incr SQL backups by BE is not interrupted.
07-16-2014 12:22 AM
07-16-2014 12:23 AM
Ok, let me see if i have understood what you mean.
So i have to complete one full chain of incremental and full backup without any interuption from default backup by SQL between this cycle. Right? In this case, if am scheduling a incremental backup on weekdays (Monday to Thrusday) and Full backup on Friday, i have to run the default one only in weekend right?
07-16-2014 12:26 AM
07-16-2014 12:26 AM
That's right. However, the default backup cannot be run on weekend after the Full backup by BE as the next incremental backup will not refer to the Full backup by BE, but it will refer to the most recent backup which was the default backup on the weekend.
The default backup (if needed) must be run AFTER all the incrementals and BEFORE the full. In your case, the default backup must be run on Thu after all incrementals and before Friday's full.