01-13-2014 11:21 AM
Hello,
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?
Thanks,
-Steven
01-13-2014 11:29 AM
Hi Steven,
If you're using Advanced Open File Option in your job, turn it off and try again. Referenced below:
http://www.symantec.com/business/support/index?page=content&id=TECH38338
Thanks!
01-13-2014 12:00 PM
Hello Craig,
Yes, "Use Snapshot technology" is selected and I've chosen to use Microsoft VSS.
BUT
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,
-Steven
01-13-2014 01:25 PM
01-13-2014 02:00 PM
Hello Drmont1,
Did this occur after an upgrade to SP3?
Thanks!
-Steven
01-13-2014 02:02 PM
Yes
01-13-2014 02:08 PM
Hello Drmont1,
Good to know from real world experience. Thanks I will give that a shot and confirm with you.
Thanks!
-Steven
01-13-2014 06:25 PM
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.
01-13-2014 06:46 PM
Hello pkh,
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?
Thanks,
-Steven
01-13-2014 07:30 PM
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.
01-13-2014 07:50 PM
Hello Pkh,
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.
Thanks,
-Steven
01-13-2014 10:12 PM
01-13-2014 10:27 PM
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:
https://www-secure.symantec.com/connect/articles/backing-databases-and-files-same-tape-separate-jobs-using-backup-exec Thanks! |