We are experiencing issues with backups and replication on Sage line 500 - we have tried both application aware and non application aware (block level).
Sage Line 500 is hosted on one virtual machine, MS SQL database on a second virtual machine.
The problem we are experiencing is identical on both application aware and not, and whether we do backups/replication on either VM - The end user loses connection to the database from the client, we get the following error in the log file:
Code: Select all
[08S01]:[[Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.]:iebuildquery:iestmt_opencurs:table scheme.stockm
If anyone has any insight into backups/replication on a sage system I would appreciate any advice, I can rely on out of hours backups and replications but I'm fairly sure this shouldn't be happening especially on block level.
TIA
MadAsToast.