We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of services to our customers as possible.
The idea we landed on was to stand up SQL on the destination server, transfer a full backup, which could take several days, prepare the new SQL for live operation then transfer and restore an incremental backup of the interim period before setting it to go live.
I've never worked with incremental backups in SQL before. Should this suit our purposes without any loss of data or is there more to it that I'm missing?
Thank you in advance for any explanation.
And as a follow-up, our current automated backup strategy is Microsoft Data Protection Manager. I know incrementals are only good since the last full backup. When DPM creates a backup does that become labeled in SQL server as the last known full backup so the incremental will only backup transactions since the last DPM backup or are the two completely autonomous?