December 28, 2008 at 7:07 pm
Hi ,
I have the SQL Server 2000 and the Exchange Server 2000, Backup Exec 12.5. I do the full backup of the exchange sever everyday and the SQL Server do the weekly full backup and differtial backup daily. I set the policy of the SQL Backup in Friday for weekly full backup. But the differential backup will fail after the excahnge full backup . It will show the following error msg:
Final error: 0xe0000363 - The Backup Exec SQL Agent was not used to create the loast 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 backkup. Final error category: Resource Errors
Thanks for your help
December 29, 2008 at 12:40 pm
According to the following from Symantec , and as the error message states something is causing your backup chain to be broken. Are you positive you don't have some pre-existing SQL Agent Job or Maintenance plan that is doing a backup that would break the chain? The above link contains a query you can use to check out what backups ran when, and they should at least be able to help you to identify when and possibly what is interfering.
Also check into your exchange backup job and verify that it isn't also trying to backup the SQL instance. Make sure you check the scheduled tasks and other such methods of scheduling things to make 100% certain you don't have another backup running.
Also, I would assume it will fail if you take a transaction log backup without using BE.
Long story short some other backup job is happening, breaking the backup chain.
-Luke.
January 10, 2009 at 10:28 am
Luke has the likely suggestion here. Check the SQL Server to see if there is a backup job or maintenance plan set up that might be breaking the backup chain.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply