I see no reason to turn off your backup program during an update to Big Sur. If there is a problem, you should still be able to downgrade back to Mojave.
I would disable any automatic backups until you are happy with the upgrade. You don't say what backup app you use. If Time Machine: TM has major changes with Big Sur. I recommend keeping your old TM device untouched and starting Big Sur TM to a new disk.