I recently upgraded to Backup Exec 2012 SP3 from a Backup Exec 2012 SP1 install using LiveUpdate. After the upgrade I am no longer able to take SQL database backups with the SQL "physical consistency checks" set to on. The Job error is: 0xe00084af and the job log and history confirms that the physical consistency checks were successfull, but the Errors say:
Additionally, there are Exceptions stating that by SQL databases are corrupt files and cannot verify. I know this is not true, but I can take successfull backups of my databases when I don't select the "physical consistency checks" and then jobs complete successfully, I have even successfully restored the databases.
I'm backing up to a B2D Folder that is on an ExaGrid. I'm wondering if anyone has had these issue with SP3 or with Backup Exec in general?
Yes, "Use Snapshot technology" is selected and I've chosen to use Microsoft VSS.
This was an upgrade from SP1 to SP3 and prior to this I have always been using it. Why suddenly do I need to deselect this option and if I do, will I still be able to take good backups of SQL?
Note that I have other Backup Exec 2012 SP3 installations where I am successfully backing up SQL 2008 R2 and 2012 databases and there the option is selected.
Thank you for the quick response,
You should always turn off AOF when you are backing up databases like SQL Server or Exchange. For SQL databases, if AOF is on, you might not be able to do a redirected restore of your database.
Hmmm, I have been backing up SQL and Exchange for a long time (years) with AOF Options "on" and am able to perform successfull restores. Why all of a sudden do I need to disable it after the SP3 upgrade?
Symantec's recommendation since forever has always been AOF off for database backups. For SQL, if you are not doing redirected restore, it should be fine. For Exchange, there are some backups problems due to AOF on.
Not for nothing, but why does it say in my screenshot below from BUE 2010, that the settings apply to all backup selections in the job, including the file system and database selections...?
In this specific backup job I backup Exchange 2010.
Steven: If you split off your backups (and I did this...works like a charm!), you might want to read my article below on how I did this: