on 08-12-2020 10:59 AM
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:
Help!
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.
Thanks
-- David
Please open a support incident to deal with this issue. This appears to be too complex to be resolved in an open forum.
My assumption is that the difference is in how Windows Server 2012 handles network connections on your network.
Have you tried ADS 10 on 2012 or ADS 12 on 2008?
Are both servers on the same subnet?
Are these Virtual Machines? I ask, because VMs tend to be extremely consistent in terms of hardware and default OS settings, which is not always the case for physical machines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.