Is it possible to perform the backup on the read-only copy of a scale-out server instead of the productive server? My idea is to spare the productive server from the effort needed to do a full backup.
asked 11 Jan '11, 13:24
Unfortunately, the answer is no. The backup must happen on the server acting as the root server (or the primary server in a mirroring system). Backups require that the server performing the backup be able to control when checkpoints occur, and this is not possible on a copy node or on the mirror server.
answered 11 Jan '11, 14:45