MODE-2253 Updated backup & restore to explicitly suspend/resume any existing user transactions plus a couple of tests (unit & integration) around backup/restore within transactions.

A separate PR is required for `3.x`.