Thanks for the prompt and descriptive replies.
This is a one off event, but will be repeated in Dev, QA and Live. Once migrated, the source database server will be decommissioned. We have the opportunity to have a system outage for this, so we can perform the backup whilst all users are...