11-17-2011 06:00 AM
11-17-2011 06:32 AM
Hi Philip,
>> AOFO is Avaiable Free of Cost and Is no longer require seprate licence
>> AOFO need to be enabled to backup open Files still even in 2003
>> enabling AOFO on database files like *.MDF, *EDB might endanger integrity of the database.
(use offline backup without agent or Online backup using its Agent)
>> The Reason for the files are skiped is normal as it would be in the global exlcusion list of BE to skip the mdf,ldf,edb etc.. files.
>> If AOFO is disabled in the backup job properties, select the option "Never" under Backup Job Properties > Advanced > Open file backup when Advanced Open File Option is not used and recreate the backup job to avoid this error.
>> Deleting the selections and submitting the job and then recreating the selections also resolves the issue
11-17-2011 06:37 PM
You should have separate jobs to backup flat files and databases. To backup flat files, you should turn on AOFO to handle opened files. When you backup databases, you should turn off AOFO.
11-18-2011 05:37 AM
That's exactly the setup I have. The SQL backup doesn't have AOFO enabled and it's fine. The flat file backup has it enabled and it's failing. It seems to have failed again last night, after I changed the 'Open file backup when Advanced Open File Option is not used' setting to Never as suggested.
Also, the file backup is taking longer and longer each night. On Tuesday it took 11h 17m before failing on verify. On Wednesday it was 16h 27m, despite the byte count being 12GB smaller because I tweaked the selection list, before failing at the same point. Last night it got up to 16h 26m before I cancelled just now, with the byte count nowhere near the total of the previous two nights (although now that I've cancelled it the byte count is actually much higher than it was shown as before I cancelled it). Again, it was stuck on Verify.
If there is a problem getting a handle on the snapshot (whatever that means) would Backup Exec keep trying over and over again before finally timing out, causing my backup to take a long time? Backing up exactly the same selection list on my old server only used to take 8 hours.
11-18-2011 05:54 PM
Try your backup with AOFO on and selecting the Microsoft VSS provider, instead of automatic.