We have just moved our main database from Advantage 10 running on Server 2008 R2 to Advantage 12 running on Server 2012.
We have found an issue using the sp_BackupFreeTables stored procedure. If the destination is a local hard disk (either a drive/directory name, or a UNC path that resolves to a local hard disk) then the backup runs at the same speed as we were seeing on ADS 10/Server 2008. If the destination is not a local hard disk, then we find that the speed of the backup is extremely slow - up to 25 times longer. This occurs for both shares on another server, and shares on a NAS drive. The level of SMB does not appear to be a a factor.
Further, and more worrying, in some cases we have seen backups that appear to complete successfully, in that "execute procedure sp_backupfreetables(...)" does not return an error, but the data backed up is incomplete.
What we have done:
Management are suggesting that we will have to go back to ADS 10/Server 2008 installation if we can't find a resolution quickly, and if that has to happen then it will be what one of my colleagues calls a "career-limiting moment". I've run out of ideas on where to look.